select * from user_objects where object_type='PROCEDURE'
根据关键字查找使用中的存储过程
select t.name,t.text from all_source t where type = 'PROCEDURE' and text like