테이블 layout 추출하기
[ORACLE VERSION 9i] SELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME, B.DATA_TYPE, B.DATA_LENGTH, A.COMMENTS FROM USER_COL_COMMENTS A, USER_TAB_COLS B, USER_TAB_COMMENTS C WHERE A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.TABLE_NAME = C.TABLE_NAME AND A.TABLE_NAME LIKE 'T_%'; [ORACLE VERSION 8I] SELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME, B.DATA_TYPE, B.DATA_LENGTH, A.C..