过程与表
如何用SQL语句得到，
哪些过程或函数中
用到了表test？
[34 byte] By [msdn] at [2007-8-14 15:34:27] 
# 1 Re: 过程与表
select object_name from all_objects
where object_ID IN (
select A.REFERENCED_OBJECT_ID from PUBLIC_DEPENDENCY A,all_objects B
WHERE A.OBJECT_ID= B.object_id AND B.object_name ='TEST')
Petergepeter at 2004-5-14 15:18:17 >
# 2 Re: 过程与表
select name from dba_dependencies where REFERENCED_NAME='TEST'
drabit at 2004-5-14 18:00:12 >
# 3 Re: 过程与表
select distinct name from dba_source where type='PROCEDURE' and instrb(text,upper('table_name'))!=0
ATCG at 2004-6-9 13:19:23 >