dba_dependencies scripts

set lines 132

select distinct
   owner,
   name,
   referenced_name
from
   dba_dependencies
where
   type in ('PACKAGE BODY','PROCEDURE','TRIGGER')
and
   referenced_type = 'SEQUENCE';

select
   referenced_name,
   referenced_type
from
   dba_dependencies
where
   name='my_tablename';

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23895263/viewspace-693838/，如需轉載，請註明出處，否則將追究法律責任。