使用下列语句可以查询存储过程中引用了哪些表.
select *
from user_dependencies t
where t.type = 'PROCEDURE'
and t.referenced_type = 'TABLE'
and t.NAME = '存储过程名称';
select *
from user_dependencies t
where t.type = 'PROCEDURE'
and t.referenced_type = 'TABLE'
and t.NAME = '存储过程名称';