오라클 프로시저 목록

     SELECT OBJECT_NAME, STATUS 
           , TO_CHAR(CREATED,'YYYY-MM-DD HH24:mi:ss') as CREATED 
           , TO_CHAR(LAST_DDL_TIME,'YYYY-MM-DD HH24:mi:ss') as LAST_DDL_TIME 
     FROM USER_OBJECTS  
     WHERE  OBJECT_TYPE = 'PROCEDURE' 
        AND OBJECT_NAME LIKE '%PRO_IF_T_%'