ORACLE查看对象（表）被哪些对象引用，查看对象（存储过程）引用的对象、查看存储...

mahan

–查看对象（表）被哪些对象引用

select * from all_dependencies t where t.name=upper(‘PROC_QY_TXL_SYN’);

–查看对象（存储过程）引用的对象

select * from all_dependencies t where t.referenced_name=upper(‘qy_user’);

–查看存储过程代码

select wm_concat(text) from user_source t where t.name=upper(‘PROC_QY_TXL_SYN’) order by line;