1. 테이블 조회
/** 전체조회 **/
SELECT * FROM ALL_ALL_TABLES;
SELECT * FROM ALL_ALL_TABLES WHERE OWNER = '소유자명';
SELECT * FROM ALL_OBJECTS;
SELECT * FROM ALL_OBJECTS WHERE OWNER = '소유자명' AND OBJECT_TYPE = '테이블명';
/** 접속한 계정기준조회 **/
SELECT * FROM TABS;
SELECT * FROM USER_TABLES;
SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME = '테이블명';
2. 컬럼 조회
/** 전체조회 **/
SELECT * FROM COLS;
SELECT * FROM COLS WHERE TABLE_NAME = '테이블명';
SELECT * FROM ALL_TAB_COLS;
SELECT * FROM ALL_TAB_COLS WHERE OWNER = '소유자명' AND TABLE_NAME = '테이블명';
/** 접속한 계정기준조회 **/
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = '테이블명';
3. (테이블) 코멘트 조회
/** 전체조회 **/
SELECT * FROM ALL_TAB_COMMENTS;
SELECT * FROM ALL_TAB_COMMENTS WHERE OWNER = '소유자명';
/** 접속한 계정기준조회 **/
SELECT * FROM USER_TAB_COMMENTS;
4. (컬럼) 코멘트 조회
/** 전체조회 **/
SELECT * FROM ALL_COL_COMMENTS;
SELECT * FROM ALL_COL_COMMENTS WHERE OWNER = '소유자명';
/** 접속한 계정기준조회 **/
SELECT * FROM USER_COL_COMMENTS;