SELECT T1.COLUMN_NAME,

       SUBSTR(DATA_TYPE||'('||DATA_LENGTH||')', 0, 20) AS DATA_TYPE,

       DECODE(NULLABLE,'N','NOT NULL', '') AS NULL_STATUS, COMMENTS

FROM ALL_TAB_COLUMNS T1, ALL_COL_COMMENTS T2

WHERE T1.TABLE_NAME = T2.TABLE_NAME

      AND T1.COLUMN_NAME = T2.COLUMN_NAME

      AND T1.TABLE_NAME = 'TB_MEMBER'

ORDER BY COLUMN_ID;


저작자 표시 비영리 변경 금지
신고
posted by 뚱2
1 2 3 4 5 6 7 8 9 ... 1011