Oracle 객체 정보 조회

객체 리스트 조회

SELECT *

FROM USER_OBJECTS

WHERE object_type = 'INDEX';

객체 TYPE 조회

SELECT object_type

FROM USER_OBJECTS

GROUP BY object_type;

객체 ARGUMENT 정보 조회

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 = 'PROCEDURE'

AND O.OBJECT_ID = A.OBJECT_ID

AND A.ARGUMENT_NAME IS NOT NULL

ORDER BY O.OBJECT_NAME, A.POSITION

특정 칼럼을 사용하는 객체 조회

SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = '사용자' AND COLUMN_NAME = '칼러명';