oracle查询表字段和注释

查看某个某个字段的注释名等

select 
  a.owner  as 用户名
  ,a.TABLE_NAME as 表名
  ,b.COMMENTS as 表注释名
  ,a.COLUMN_NAME as 字段名
  ,a.comments  as 字段注释
from dba_col_comments a
join dba_tab_comments b  
on a.table_name=b.table_name
 where  a.owner='OPPY'  
 and  a.comments like '%名称%'