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!

Derive Hierarhical tree for Tables using Data Dictionary

149764Mar 18 2004 — edited Mar 21 2004

I need to derive the Hierarchical tree for Tables in my database using the data dictionary meta data. When I tried to run query using CONNECT BY PRIOR clause it generated ORA-01436: CONNECT BY loop in user data.
Can any body tell me how to generate this tree?

TIA.
Dharmesh Patel

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2004

Added on Mar 18 2004

3 comments

204 views