what is the query to fetch duplicate records in oracle table.
I think it's the same with SQL:
select field1 ,count(*) from table group by field1 having count(*) > 1
select * from table where field1 in (select field1 from table group by field1 having count(*) > 1 )
What exactly you mean by duplicate records.
Duplicate based on what ?
select <column_name>,count(*) from <table_name> group by <column_name> having count<column_name> >1
If you wanna fetch and check through the duplicates, you'd gotta use a cursor.