Oracle查询所有资源

--查询存储过程、包、函数
select * from all_procedures a where upper(a.PROCEDURE_NAME) = upper('fee_sp');

--查询所有的资源(存储过程、函数、包的源码)
select * from all_source a where a.owner = 'PERFREWARD' and a.name = 'CLR_ERR_SP';