Oracle查询数据字典

查询数据是根据当前账号权限进行查询，若有分库分账号的数据库够，为查询出数据，更换当前数据库账号再进行查询

查询库下表的数据字典

select  atc.table_name as 表名, 
        utc.comments as 表说明,
        rownum as 序号,
        atc.column_name as 字段名,
        atc.data_type as 数据类型,
        atc.data_length as 长度,
        decode(atc.nullable,'N','否','是') as 允许空,
        nvl(atc.data_default,'') as 默认值,
        ucc.comments 说明
from
    (
     select atc.owner,
            atc.table_name,
            atc.column_name,
            atc.data_type,
            atc.data_length,
            atc.nullable,atc.data_default
     from all_tab_columns atc
     /*可具体查询到某张表的数据字典*/
     /*where atc.owner in ('****_STANDARD') 
             and atc.table_name in ('DATA_ITEM_CATALOG')*/
    ) atc
left outer join user_col_comments ucc
             on atc.table_name=ucc.table_name and 
                atc.column_name=ucc.column_name
left outer join user_tab_comments utc
             on atc.table_name=utc.table_name
  where ucc.comments  is not null

查询某张表的字段及注释

select column_name,comments
from user_col_comments
where TABLE_NAME='DATA_ITELOG'

查询库下所有的表名及表注释

select * from USER_TAB_COMMENTS

查询库下所有表中的字段名及字段注释

select * from USER_COL_COMMENTS