Oracle 수정일 조회(PROCEDURE, FUNCTION 등)

SELECT OBJECT_NAME

,OBJECT_TYPE

,TO_CHAR(CREATED, 'YYYYMMDD') AS CREATED

,TO_CHAR(LAST_DDL_TIME, 'YYYYMMDD') AS LAST_DDL_TIME

,STATUS

FROM USER_OBJECTS       

WHERE OBJECT_TYPE = 'PROCEDURE'            -- PROCEDURE, FUNCTION .......

AND TO_CHAR( LAST_DDL_TIME, 'YYYYMMDD' ) > SYSDATE - 1;

-- DBA 권한 있으면 DBA_OBJECTS 가능 조건에 OWNER 조건 추가해서 검색 가능