SELECT O.OBJECT_NAME, O.OBJECT_ID,O.OBJECT_TYPE, O.STATUS
, A.ARGUMENT_NAME, A.POSITION, A.SEQUENCE, A.DATA_LEVEL, A.DATA_TYPE, A.IN_OUT, A.DATA_LENGTH
FROM USER_OBJECTS O, USER_ARGUMENTS A
WHERE O.OBJECT_TYPE = 'FUNCTION'
AND O.OBJECT_ID = A.OBJECT_ID
AND A.ARGUMENT_NAME IS NOT NULL
-- AND A.POSITION = 0
ORDER BY O.OBJECT_NAME, A.POSITION
, A.ARGUMENT_NAME, A.POSITION, A.SEQUENCE, A.DATA_LEVEL, A.DATA_TYPE, A.IN_OUT, A.DATA_LENGTH
FROM USER_OBJECTS O, USER_ARGUMENTS A
WHERE O.OBJECT_TYPE = 'FUNCTION'
AND O.OBJECT_ID = A.OBJECT_ID
AND A.ARGUMENT_NAME IS NOT NULL
-- AND A.POSITION = 0
ORDER BY O.OBJECT_NAME, A.POSITION
이렇게 고마울수가 ㅠㅠ
눈물이 다 난다..
DB 담당자 라면 이쯤은 알아야 하지 않을까??
이 외에 오브젝트 타입 별로
INDEX
PROCEDURE
TABLE
VIEW
FUNCTION
DATABASE LINK
SYNONYM
LOB
SEQUENCE
이런 것들이 조회 가능하다
멋지지 않나? ㅠㅠ