oracle 查询表重复字段

select 字段名,count(1) from 表名 group by 字段名 having count(1) > 1;