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/