SELECT ROWNUM ROWNM,
AA.OWNER,
AA.TABLE_NAME,
-- A.COLUMN_ID,
AA.COLUMN_NAME,
AA.TABLE_COMMENTS,
AA.COLUMN_COMMENTS,
AA.DATA_TYPE,
AA.DATA_LENGTH,
AA.NULLABLE
FROM ( SELECT A.OWNER,
TRIM (A.TABLE_NAME) TABLE_NAME,
-- A.COLUMN_ID,
TRIM (A.COLUMN_NAME) COLUMN_NAME,
TRIM (B.COMMENTS) TABLE_COMMENTS,
TRIM (C.COMMENTS) COLUMN_COMMENTS,
A.DATA_TYPE,
A.DATA_LENGTH,
A.NULLABLE
FROM ALL_TAB_COLUMNS A, ALL_TAB_COMMENTS B, ALL_COL_COMMENTS C
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_NAME = C.TABLE_NAME
AND B.TABLE_NAME = C.TABLE_NAME
AND A.COLUMN_NAME = C.COLUMN_NAME
AND B.COMMENTS IS NOT NULL
AND C.COMMENTS IS NOT NULL
GROUP BY A.OWNER,
A.TABLE_NAME,
-- A.COLUMN_ID,
A.COLUMN_NAME,
B.COMMENTS,
C.COMMENTS,
A.DATA_TYPE,
A.DATA_LENGTH,
A.NULLABLE
ORDER BY TABLE_NAME) AA
WHERE OWNER = 'ENV' AND COLUMN_NAME = 'CHCK_MANAGE_NO'