select distinct name from USER_SOURCE where type = ‘PROCEDURE‘ and text like ‘%你要查找的内容 %‘
oracle如何在所有procedure里搜索某些关键字, 存储过程
原文：https://www.cnblogs.com/jijm123/p/14523092.html
