oracle finding duplicate records

SELECT column_name, COUNT(column_name)<br /><br /> FROM table_name<br /><br /> GROUP BY column_name<br /><br /> HAVING COUNT(column_name) > 1;