SELECT OBJECT_TYPE,
OBJECT_NAME,
STATUS,
TO_CHAR( CREATED, 'YYYY.MM.DD' ) AS CREATED,
TO_CHAR( LAST_DDL_TIME, 'YYYY.MM.DD' ) AS LAST_DDL_TIME
FROM USER_OBJECTS
WHERE OBJECT_TYPE IN ( 'FUNCTION', 'PROCEDURE' )
AND TO_CHAR( LAST_DDL_TIME, 'YYYYMMDD' ) > '20151006'
ORDER BY OBJECT_TYPE,
OBJECT_NAME
SELECT TYPE,
NAME,
LINE,
TEXT
FROM USER_SOURCE B
WHERE TYPE IN ( 'FUNCTION', 'PROCEDURE' )
AND TEXT LIKE '%''TEXT''%'
ORDER BY TYPE,
NAME,
LINE
[출처] 오라클 프로시저, 펑션 수정일, 내용으로 조회하기|작성자 지환이아빠