recursive sql call

[DavidSherring]

I have a table with a key, and a previous key. I need to recursively step through the table until I have the key with no previous key (i.e the original record). Is there an sql command I can use to do this, or do I need to program?

Field Names are

resource_bookings.resource_bookings_id and resource_bookings.previous_sequence_id

previous sequence_id will hold resource_bookings_id of previous record. I need the original from whence to go and get data.

Please help

 

[taupirho]

Check out Oracle Analytic functions, specifically LEAD and LAG


In order to understand recursion, you must first understand recursion.

 

[sem]

Have you ever heard about START WITH..CONNECT BY construct?

Regards, Dima

http://seminihin.narod.ru