Database

"how to find duplicate records in oracle data base" 
select *
from table
group by key1, key2, ..., keyN
having count (*) > 1;
http://www.dba-oracle.com/t_delete_duplicate_table_rows.htm