title: Find the entire tree from the root giving any node
body: <p>How do I find the entire tree given a node of a tree?</p>
  
  <p>Example of tree:</p>
  
  <pre><code>       100
    101        102
  1010 1011   1020  1021
  
  
  select level, employee_id, last_name, manager_id ,
         connect_by_root employee_id as root_id
    from employees
   connect by prior employee_id = manager_id
   start with employee_id = 101
  ;
  </code></pre>
  
  <p>The root in table is (parent,child) example (100,101) there is no (null,100) row in table.</p>
  
  <p>The above query only gives the children starting from 101. But lets say I want everything from the start of the root?</p>
  
  <p>When given '101' as the node, you won't know which is the root.</p>
  
  <p>The query should be usable when the root is the given node.</p>