오라클 프로시저 목록
DB/Oracle
2021. 1. 22. 16:38
반응형
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_%'
반응형