Oracle : find duplicate row and total duplicate

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