[Oracle] 오라클 컬럼명, 테이블 조회
SELECT ROWNUM ROWNM, AA.OWNER, AA.TABLE_NAME, -- A.COLUMN_ID, AA.COLUMN_NAME, AA.TABLE_COMMENTS, AA.COLUMN_COMMENTS, AA.DATA_TYPE, AA.DATA_LENGTH, AA.NULLABLE FROM ( SELECT A.OWNER, TRIM (A.TABLE_NAME) TABLE_NAME, -- A.COLUMN_ID, TRIM (A.COLUMN_NAME) COLUMN_NAME, TRIM (B.COMMENTS) TABLE_COMMENTS, TRIM (C.COMMENTS) COLUMN_COMMENTS, A.DATA_TYPE, A.DATA_LENGTH, A.NULLABLE FROM ALL_TAB_COLUMNS A, AL..
2018. 12. 26.