Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Redundancy Issue in Table

NarenAug 14 2009 — edited Aug 14 2009
Hi all,
i have a table CLAIM which consists of around 1million records which are infact duplicated.. original is 34231 records .

I need to remove all the other duplicate records , with just maintaining unique records in that table.. how can i do that..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2009
Added on Aug 14 2009
23 comments
3,691 views