根据内容查存储过程

1.Oracle中下面这么写 

按名查找存储过程： 
select   *   from   user_objects  
    where   Object_Type='PROCEDURE' and object_name like '%'||upper('p')||'%' 

按内容查找存储过程： 
SELECT * FROM ALL_SOURCE  where TYPE='PROCEDURE'  AND TEXT LIKE '%'||upper('clean_')||'%' 

SELECT * FROM ALL_SOURCE  where TYPE='PACKAGE BODY' AND TEXT LIKE '%function%'and owner='system' and name='tablename';
有点慢，MS没什么好方法 

2.MS Server中下面这么写 

按名查找存储过程： 
EXEC Sp_HelpText '存储过程名'; 

按内容查找存储过程： 
select b.name 
from kbmp.dbo.syscomments a,kbmp.dbo.sysobjects b 
where a.id=b.id  and b.xtype='p' and a.text like '%if_check%';