Oracle Query to find duplicate record in a table

select count(field_name),field_name from table_name
where field_name
group by field_name
having count(field_name) > 1 ;