ORACLE
오라클에서 컬럼 Comments 조회하기.
구름너머
2005. 12. 22. 15:40
--COMMENTS
SELECT B.COLUMN_ID, B.COLUMN_NAME, A.COMMENTS,
decode(b.data_type,'FLOAT',b.data_type,'DATE',b.data_type,B.DATA_TYPE||'('||decode(b.data_precision,null,B.DATA_LENGTH,b.data_precision)||')') TYPES,
DECODE(B.NULLABLE,'Y','Y',B.NULLABLE) ISNULL
FROM ALL_COL_COMMENTS A,
--(SELECT * FROM cols WHERE TABLE_NAME = 'TB_MAILHOSTING') B
(SELECT * FROM all_tab_columns WHERE TABLE_NAME = :vTable_Name and owner='BILL') B
WHERE A.TABLE_NAME(+) = :vTable_Name
AND A.COLUMN_NAME(+) = B.COLUMN_NAME
AND A.owner='BILL'
ORDER BY B.COLUMN_ID
SELECT B.COLUMN_ID, B.COLUMN_NAME, A.COMMENTS,
decode(b.data_type,'FLOAT',b.data_type,'DATE',b.data_type,B.DATA_TYPE||'('||decode(b.data_precision,null,B.DATA_LENGTH,b.data_precision)||')') TYPES,
DECODE(B.NULLABLE,'Y','Y',B.NULLABLE) ISNULL
FROM ALL_COL_COMMENTS A,
--(SELECT * FROM cols WHERE TABLE_NAME = 'TB_MAILHOSTING') B
(SELECT * FROM all_tab_columns WHERE TABLE_NAME = :vTable_Name and owner='BILL') B
WHERE A.TABLE_NAME(+) = :vTable_Name
AND A.COLUMN_NAME(+) = B.COLUMN_NAME
AND A.owner='BILL'
ORDER BY B.COLUMN_ID