title: Find all nodes in an adjacency list model with oracle connect by
body: <p>Given the following model:</p>
  
  <pre><code>create table child_parent (
    child number(3),
    parent number(3)
  );
  </code></pre>
  
  <p>Given the following data:</p>
  
  <pre><code>insert into child_parent values(2,1);
  insert into child_parent values(3,1);
  insert into child_parent values(4,2);
  insert into child_parent values(5,2);
  insert into child_parent values(6,3);
  </code></pre>
  
  <p>results in the following tree:</p>
  
  <pre><code>        1
         / \
        2   3
       / \   \
      4   5   6
  </code></pre>
  
  <p>Now i can find the parents of 5 like this:</p>
  
  <pre><code>SELECT parent FROM child_parent START WITH  child = 5 
                CONNECT BY NOCYCLE PRIOR parent = child;
  </code></pre>
  
  <p>But how can I get all the nodes (1,2,3,4,5,6) starting from 5?</p>