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