title: oracle 9i get highest member of tree with given child
body: <p>I have a parent-child relationship in an Oracle 9i database-table</p>
  
  <p>like:</p>
  
  <pre><code>parent | child  
  1      | 2  
  2      | 3
  2      | 4
  null   | 1
  1      | 8
  </code></pre>
  
  <p>I need to get the absolute parent from a given child.
  Say, I have child 4, it has to give me parent: 1</p>
  
  <p>I already looked to CONNECT BY , but I can't find the solution.</p>