ORACLE 객체 조회

ORACLE 객체 조회

SELECT *
FROM   ALL_OBJECTS
WHERE  OBJECT_TYPE = 'PROCEDURE'
AND OWNER = 'GITS';

객체 TYPE

JOB CLASS
INDEX
TYPE BODY
INDEXTYPE
PROCEDURE
JAVA CLASS
SCHEDULE
WINDOW
WINDOW GROUP
JAVA RESOURCE
TABLE
TYPE
VIEW
FUNCTION
TRIGGER
SYNONYM
PACKAGE BODY
CONSUMER GROUP
EVALUATION CONTEXT
OPERATOR
JAVA DATA
PACKAGE
SEQUENCE
LOB

테이블, 프로시저, 패키지 목록 가져오기 

SELECT * FROM ALL_OBJECTS;

SELECT * FROM SYS_OBJECTS;

SELECT * FROM USER_OBJECTS;

프로시저, 패키지 내용 가져오기 

SELECT * FROM USER_SOURCE;

SELECT * FROM ALL_SOURCE;

컬럼 목록 가져오기 

SELECT * FROM COLS; 

[출처] oracle - 오라클에서 패키지 내용 쿼리하기 등등...|작성자 끙애내꼬