SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recursive query for finding parents and children against two tables

569196Jan 14 2010 — edited Jan 15 2010

Hi I have two tables where the data is stored hierarchially.
I have found using connect_by, level and other oracle functions doing its job when the data is in one table.

Can I traverse against two tables by using the same oracle functions.

My Table A can go 2 levels deep in my hierarchy and level 3 and so forth has to be done against a different table.

Appreciate your insight..

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2010

Added on Jan 14 2010

4 comments

1,318 views