Table Comment, Column Comment

1. Table Comments

SELECT T1.TABLE_NAME, 

      T2.COMMENTS TABLE_COMMENT

  FROM USER_TABLES T1,

     USER_TAB_COMMENTS T2

WHERE T2.TABLE_NAME(+) = T1.TABLE_NAME 

     AND T1.TABLE_NAME = [테이블이름]

ORDER BY 1, 2;

2. Select Column Comments

SELECT T.COLUMN_NAME AS PHYSICAL_NAME,

            C.COMMENTS AS LOGICAL_NAME,

            T.DATA_TYPE AS TYPE,

            CASE WHEN T.DATA_TYPE = 'NUMBER' THEN T.DATA_PRECISION

            ELSE CASE WHEN T.CHAR_LENGTH != 0 THEN T.CHAR_LENGTH ELSE NULL END

            END AS LENGTH,

            T.DATA_SCALE,

            T.DATA_DEFAULT,

            T.NULLABLE

  FROM ALL_TAB_COLUMNS T, 

ALL_COL_COMMENTS C

WHERE T.TABLE_NAME = C.TABLE_NAME

    AND T.COLUMN_NAME = C.COLUMN_NAME

    AND T.TABLE_NAME = [테이블이름]

ORDER BY T.COLUMN_ID ASC;

*** USER_TABLES, USER_TAB_COMMENTS, USER_TAB_COLUMNS, USER_COL_COMMENTS는

ALL_~ 로 대체가능