select * from all_object a where a.object_type=‘procedure‘ and a.object_name like ‘%XXX%‘;
如何查看oracle中存储过程的内容
原文：http://7883830.blog.51cto.com/7873830/1582409
