Table properties for Oracle

properties.sql

SELECT A.TABLE_NAME TABLE_NAME
            ,B.COMMENTS TAB_COMMENTS
            ,C.COLUMN_ID COLUMN_ID
            ,C.COLUMN_NAME COLUMN_NAME
            ,D.COMMENTS COL_COMMENTS
            ,C.DATA_TYPE DATA_TYPE
            ,DECODE(C.DATA_TYPE,'CHAR', TO_CHAR(C.DATA_LENGTH)
                         ,'VARCHAR', TO_CHAR(C.DATA_LENGTH)
                         ,'VARCHAR2', TO_CHAR(C.DATA_LENGTH)
                         ,'NUMBER', TO_CHAR(C.DATA_PRECISION)||DECODE(NVL(C.DATA_SCALE,''),0,'',','
                        ||TO_CHAR(NVL(C.DATA_SCALE,''))), 'CLOB','')DATA_LENGTH
            ,C.NULLABLE NULLABLE
            ,NVL(C.DATA_DEFAULT,'') DATA_DEFAULT
  FROM USER_TABLES A
           ,USER_TAB_COMMENTS B
           ,USER_TAB_COLUMNS C
           ,USER_COL_COMMENTS D
WHERE A.TABLE_NAME = B.TABLE_NAME(+)
     AND A.TABLE_NAME = C.TABLE_NAME
     AND C.TABLE_NAME = D.TABLE_NAME(+)
     AND C.COLUMN_NAME= D.COLUMN_NAME(+)
     AND A.TABLE_NAME = '테이블명'  -- 원하는 테이블명을 넣으시오
 ORDER BY A.TABLE_NAME,C.COLUMN_ID