Oracle查询某个表被那些存储过程引用
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
select * from user_dependencies where upper(referenced_name) = 'tablename' ; SELECT DISTINCT * FROM user_source WHERE TYPE = 'PROCEDURE' AND upper(text) LIKE '%tablename%';
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