날아라 슈퍼코더

--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 || '%'