: I would like to know the oracle (SQL) query to find the duplicate records in a oracle data base.
: Kindly help me.
: Thanks in advance,
By duplicate records I presume you mean records with similar keys?
(Which begs the question as to why your primary key constraint didn't kick out the duplicate entries!)
group by key1, key2, ..., keyN
having count (*) > 1;
If you want to list them for a data cleanup excercise add an order by clause to list them in the order you want.
Think it through first - then pester someone.