查看某个表,或字段所涉及的存储过程
select * from all_source where type = 'PROCEDURE' and upper(text) like '%PO_NO%'; -- PO_NO字段名,或表名
select * from user_source where type = 'PROCEDURE' and upper(text) like '%PO_NO%'; -- PO_NO字段名
查询所有的JOB
select * from all_jobs;
select * from user_jobs;