select *
from all_tab_cols a
where a.column_name = '字段名'
and a.owner = '数据库用户名'
and a.table_name not in
(select t.tname from tab t where t.tabtype = 'VIEW')
select *
from all_tab_cols a
where a.column_name = '字段名'
and a.owner = '数据库用户名'
and a.table_name not in
(select t.tname from tab t where t.tabtype = 'VIEW')