oracle 看所有字段信息

--看所有字段信息
select a.*
  from mw_sys.MWT_OM_ATTR a, mw_sys.mwt_om_cls b
 where a.cls_id = b.cls_id
   and b.cls_tabname = 'PM_BZ_DDRZ_YCQX'
 order by a.attr_dispidx
         
--看基础四项
select a.attr_colname, --字段列名
       dbit_id || decode(attr_kind,
                         'D',
                         decode(attr_collength, 0, '',
                                '(' || attr_collength ||
                                decode(attr_colscale, 0, ')',
                                       ',' || attr_colscale || ')')), '') attr_kind, --数据类型
       decode(attr_isnullable, 'T', 'Y', 'N') isnullable, --是否为空
       a.attr_name --属性名
  from mw_sys.MWT_OM_ATTR a, mw_sys.mwt_om_cls b
 where a.cls_id = b.cls_id
   and b.cls_tabname = 'PM_NW_ZH_TCLB'
 order by a.attr_dispidx;

--加注释
--comment on column pm_nw_zh_tclb.nf is '年份';
select 'comment on column PM_NW_SW_FDJZTCTJ.'||a.attr_colname||' is '''||a.attr_name||''';'
  from mw_sys.MWT_OM_ATTR a, mw_sys.mwt_om_cls b
 where a.cls_id = b.cls_id
   and b.cls_tabname = 'PM_NW_SW_FDJZTCTJ'
 order by a.attr_dispidx;