oracle查询某表中是否含有某字段
oracle查询某表中是否含有某字段
查询某表中是否含有某字段
[sql]
select col.column_name,
col.DATA_TYPE || ' (' || col.DATA_PRECISION || ')',
col.DATA_TYPE || ' (' || col.DATA_LENGTH || ')',
col.OWNER
from all_Tab_Columns col
where table_name = 'WBJH_HG_CXCKHWBGD'
and column_name /*not*/
in ('XH', 'ZB_XH', 'BGDH_1', 'CXBS', 'FWBS');
