SELECT A.TABLE_NAME , ( SELECT C.COMMENTS FROM DBA_TAB_COMMENTS C WHERE A.OWNER = C.OWNER AND A.TABLE_NAME = C.TABLE_NAME ) AS TABLE_COMMENTS ,B.COLUMN_ID AS COLUMN_NO ,B.COLUMN_NAME ,( SELECT D.COMMENTS FROM DBA_COL_COMMENTS D WHERE A.OWNER = D.OWNER AND A.TABLE_NAME = D.TABLE_NAME AND B.COLUMN_NAME = D.COLUMN_NAME ) AS COLUMN_COMMENTS , B.DATA_TYPE , CASE WHEN B.DATA_TYPE IN ('VARCHAR', 'VARCH..