title: Oracle SQL hierarchical query from bottom to top element
body: <p>In my table I store the successor of each entry.</p>
  
  <pre>
  +----+-----------+--+
  | ID | SUCCESSOR |  |
  +----+-----------+--+
  |  1 |         2 |  |
  |  2 |         3 |  |
  |  3 |           |  |
  +----+-----------+--+
  </pre>
  
  <p>I need to get from <strong>ID 3</strong> to <strong>ID 1</strong>.</p>
  
  <p>I have tried to archieve this with the following query, but this does not work. :-(</p>
  
  <pre><code>SELECT NVL (id, 3)
  FROM my_table
  WHERE LEVEL = 1
  CONNECT BY id = PRIOR successor
  START WITH id = 3;
  </code></pre>
  
  <p>Can somebody please give me some advice how to get this working?</p>