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

* 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

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

标签：spl   text   task   mac   comm   click   存储   type   splay