oracle查询引用某表的存储过程的sql语句
SELECT DISTINCT name FROM all_source WHERE lower(text) LIKE '%table_you_want_to_find%'
或者
SELECT DISTINCT name FROM all_source WHERE upper(text) LIKE '%TABLE_YOU_WANT_TO_FIND%'

我的异常网推荐解决方案：oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html