--table comment 검색
SELECT A.OWNER
, A.TABLESPACE_NAME
, A.TABLE_NAME
, B.COMMENTS
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND B.COMMENTS LIKE '%'||:cmnt||'%'
--column comment 검색
SELECT A.OWNER
, A.TABLESPACE_NAME
, A.TABLE_NAME
, B.COMMENTS AS COMMENT_T
, C.COLUMN_NAME
, D.COMMENTS AS COMMENT_C
, C.DATA_TYPE
, C.DATA_LENGTH
, C.DATA_PRECISION
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
, ALL_TAB_COLUMNS C
, ALL_COL_COMMENTS D
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND D.COMMENTS LIKE '%'|| :cmnt || '%'
SELECT A.OWNER
, A.TABLESPACE_NAME
, A.TABLE_NAME
, B.COMMENTS
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND B.COMMENTS LIKE '%'||:cmnt||'%'
--column comment 검색
SELECT A.OWNER
, A.TABLESPACE_NAME
, A.TABLE_NAME
, B.COMMENTS AS COMMENT_T
, C.COLUMN_NAME
, D.COMMENTS AS COMMENT_C
, C.DATA_TYPE
, C.DATA_LENGTH
, C.DATA_PRECISION
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
, ALL_TAB_COLUMNS C
, ALL_COL_COMMENTS D
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND D.COMMENTS LIKE '%'|| :cmnt || '%'