Re: duplicates
From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1995/08/01
Message-ID: <DCMvxK.4n2_at_twisto.eng.hou.compaq.com>#1/1
Date: 1995/08/01
Message-ID: <DCMvxK.4n2_at_twisto.eng.hou.compaq.com>#1/1
ucfaabe_at_ucl.ac.uk (Mr Angus Beare) wrote:
>
>
> I have a table that I want to create a unique index for
> but I can't because of duplicates. Oracle won't tell
> me where they are.
>
> Does anyone know a quick way to find duplicate records?
>
> thanks for any suggestions
>
> Gus
>
> --
> Angus Beare
The previous two examples you got will show you the duplicates, but
if you need to delete records and keep one instance of the duplicates,
include ROWID as one of the select items. You can use it to delete
specific rows using the "where rowid='xxxxxxxx.yyyy.zzz'" criteria on
the delete statement.
Kim Hughes
DRT Systems International
Houston, TX
Received on Tue Aug 01 1995 - 00:00:00 CEST