June 26, 2013

How to get table dependencies in oracle database

How to find which two or more tables related with each others among n number of tables in database. You can try following query.

select * from dba_dependencies where referenced_link_name is not null;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.