查看存储过程中所用到的表
方式一
SELECT *
FROM sys.all_DEPENDENCIES
WHERE REFERENCED_NAME = upper('table_name');
方式二
select *
from sys.dba_source
where text like upper('%table_name%');
查看存储过程中所用到的表
方式一
SELECT *
FROM sys.all_DEPENDENCIES
WHERE REFERENCED_NAME = upper('table_name');
方式二
select *
from sys.dba_source
where text like upper('%table_name%');