oracle 快速检索表名称及包含的字段名称

**--通过字段注释  查找  对应表及对应的字段**
select * from all_col_comments a where a.COMMENTS like '%地面%' and rownum <= 40;   

**--通过表名中包含的字符查找对应的表 ，要大写**
select * from all_col_comments a where a.TABLE_NAME like '%CUST%' and rownum <= 40;      

**--通过列名中包含的字符查找对应的表，要大写**
select * from all_col_comments a where a.COLUMN_NAME like '%PARTNER_ID%' and rownum <= 40;     

**--子查询可查看表名称**
select a.*,
       (select wa.comments
          from dba_tab_comments wa
         where wa.table_name = a.TABLE_NAME) tab
  from all_col_comments a
 where a.COMMENTS like '%媒体来源%'

select a.*,
       (select wa.comments
          from dba_tab_comments wa
         where wa.table_name = a.TABLE_NAME) tab
  from all_col_comments a
 where a.COLUMN_NAME like '%OFFER_GROUP_ID%'

---

all_col_comments 查看所有表
user_col_comments 查看用户下的表