Wednesday, March 17, 2010

How to find the dependencies for PL/SQL objects

column name format a20
column referenced_owner format a15 heading R_OWNER
column referenced_name format a15 heading R_NAME
column referenced_type format a12 heading R_TYPE
select name, type, referenced_owner, referenced_name,referenced_type
from user_dependencies
order by type, name;

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home