查询存储过程下的涉及表:select *from dba_dependencies t
where t.referenced_owner=[user]
and t.type='PROCEDURE'
and t.referenced_type='TABLE'
and NAME =[PROCEDURE_NAME]
...全文
242打赏收藏
oracle系统表常用查询sql
查询存储过程下的涉及表:select *from dba_dependencies t where t.referenced_owner=[user] and t.type='PROCEDURE' and t.referenced_type='TABLE' and NAME =[PROCEDURE_NAME]