Monday, 4 December 2017

[Oracle] 테이블 컬럼명, Comment 확인

SELECT A.COLUMN_NAME, B.COMMENTS, A.DATA_TYPE
FROM COLS A, USER_COL_COMMENTS B
WHERE A.TABLE_NAME = '[TABLE_NAME]'
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
;

No comments:

Post a Comment