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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23895263/viewspace-693838/