How do I find duplicate values in a table in Oracle?

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;