프로시저 및 함수 특정문자 값 검색

/******************************************************

                       특정문자값 포함 테이블 sp검색                        

********************************************************/

SELECT * FROM USER_SOURCE where upper(TEXT) like upper('%검색내용%') ORDER BY NAME,TYPE,LINE;

SELECT * FROM USER_SOURCE where regexp_like (upper(TEXT), upper('insert into|testtable%')) ORDER BY NAME,TYPE,LINE;