Oracle 테이블 조회

--테이블 조회

SELECT * FROM USER_TABLES;

 

--컬럼 조회

SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = ':TABLE_NAME';

 

--테이블주석조회

select * from USER_TAB_COMMENTS WHERE table_name = ':TABLE_NAME';

 

--테이블컬럼주석조회

SELECT * FROM ALL_COL_COMMENTS WHERE table_name = ':TABLE_NAME';

SELECT B.TABLE_NAME,B.COLUMN_NAME

,A.COMMENTS

,B.DATA_TYPE

,B.DATA_LENGTH

,DECODE(B.NULLABLE, 'N','NOT NULL') NULLABLE

FROM DBA_COL_COMMENTS A

,DBA_TAB_COLUMNS B

WHERE A.OWNER = B.OWNER

 AND A.TABLE_NAME = B.TABLE_NAME

 AND A.COLUMN_NAME = B.COLUMN_NAME

 AND B.OWNER = ':OWNER'

 AND B.TABLE_NAME = ':TABLE_NAME'

ORDER BY B.COLUMN_ID;