Skip to Main Content

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!

SQL to list out all the objects (tables) which refrence to a agiven table.

636764Feb 4 2009 — edited Feb 4 2009
Hi All -

I want to write a SQL which will list out all the objects (tables) which refrence to a given table.

For e.g.

Lets say Table B refrence to table A.col1 and table C ref to table A.col2

Now I want a SQL which will following output:-

TABLE Refrenced by Column
A B B.col1
A C C.col4



Thanks!!!
This post has been answered by Andreas Weiden on Feb 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2009
Added on Feb 4 2009
4 comments
386 views