Search This Blog

Wednesday, February 1, 2012

Find table used by which Packages and Procedures

Query:

SELECT name FROM dba_dependencies WHERE referenced_name = <your table name> UNION SELECT referenced_name FROM dba_dependencies WHERE name = <your table name>;

No comments:

Post a Comment