Search This Blog

Showing posts with label dba. Show all posts
Showing posts with label dba. Show all posts

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>;