Re: duplicates
From: Pedro Bandeira <pbandei>
Date: 1995/08/03
Message-ID: <3vr7k1$s9i_at_midgard.calvacom.fr>#1/1
Date: 1995/08/03
Message-ID: <3vr7k1$s9i_at_midgard.calvacom.fr>#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
Assuming you are trying to enable a unique or PK constraint (manually creating unique indexes is NOT recommended), see EXCEPTIONS INTO clause, SQL language ref. manual, page 4-281.
Pedro Received on Thu Aug 03 1995 - 00:00:00 CEST