Oracle查询某个表被那些存储过程引用

 

select * from user_dependencies where upper(referenced_name) = 'tablename' ;
 
SELECT DISTINCT * FROM user_source WHERE TYPE = 'PROCEDURE' AND upper(text) LIKE '%tablename%';
View Code

 

 

https://www.cnblogs.com/wsy0202/p/12496708.html

https://blog.csdn.net/qq_26963433/article/details/98848052?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.add_param_isCf&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.add_param_isCf

posted @ 2020-09-14 11:30  bxzjzg  阅读(864)  评论(0)  编辑  收藏  举报