오라클 프로시저 , 함수 변경 이력 체크

-- 변경됬는지 체크
SELECT OBJECT_TYPE,
       OBJECT_NAME,
       STATUS,
       TO_CHAR (CREATED, 'YYYYMMDD')       AS CREATED,
       TO_CHAR (LAST_DDL_TIME, 'YYYYMMDD') AS LAST_DDL_TIME
  FROM USER_OBJECTS
 WHERE     OBJECT_TYPE IN ('FUNCTION', 'PROCEDURE')
       AND TO_CHAR (LAST_DDL_TIME, 'YYYYMMDD') >= '20210501'
       AND OBJECT_NAME = '프로시저명 or 함수명' 
       ORDER BY OBJECT_TYPE , OBJECT_NAME;


-- 변경된 부분 찾을 때
SELECT TYPE,
       NAME,
       LINE,
       TEXT
  FROM USER_SOURCE
 WHERE TYPE IN ('FUNCTION', 'PROCEDURE') 
-- AND TEXT LIKE '%수정%' 
 AND NAME = '프로시저명 or 함수명'
 ORDER BY TYPE , NAME , LINE;