REPLACE(REPLACE(MSG_KOR_TXT,'\r\n',' '),'\r',' ') AS MSG_TXT
FROM MSG

%ForEachTable() {
        COMMENT ON TABLE %TableName IS '%EntityName';
        %ForEachColumn() { 
                COMMENT ON COLUMN %TableName.%ColName IS '%AttName';
         }
}

SELECT

    A.TABLE_NAME

    , B.COMMENTS
FROM   ALL_TABLES A

        , ALL_TAB_COMMENTS B
WHERE  A.TABLE_NAME = B.TABLE_NAME
ORDER BY A.TABLE_NAME;

     A.OWNER

   , A.TABLE_NAME

   , A.COLUMN_ID

    , A.COLUMN_NAME

    , B.COMMENTS

    , A.DATA_TYPE

    , A.DATA_LENGTH

    , A.NULLABLE
FROM   ALL_TAB_COLUMNS A

     , ALL_COL_COMMENTS B
WHERE  A.TABLE_NAME = B.TABLE_NAME
      AND  A.COLUMN_NAME = B.COLUMN_NAME
      AND A.OWNER = 'SCOTT'      /*owner name*/
      AND A.TABLE_NAME = 'EMPLOY' /*table name*/
ORDER BY A.TABLE_NAME, A.COLUMN_ID