Hi, I would like to write a SQL to recursively extract data from a table. The algorithm is as follows: SQL> select * from mytable; A B ---------- ---------- 1 2 2 3 3 4 4 5 5 6 0 7 7 8 8 9 8 rows selected. If A=3, output the corresponding value of B (ie 4), then match B (ie 4) with A and output the next corresponding value of B (ie 5) and so on... Recursion stops when B != A A & B are unqiue and A=<value> is a user input value The result I'm looking for is: if A=3, then the output is: 4 5 6 if A=7, then the output is: 8 9 Is there a way to accomplish that in SQL? thanks. susan __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/