Re: DML Needed: Flag Duplicate Records....

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 06 May 2002 21:53:08 +0200
Message-ID: <cmnddukas6o6tg29mksm7geri0bus5s9p8@4ax.com>

On Mon, 6 May 2002 14:57:51 -0400, "R Chin" <rchin_at_panix.com> wrote:

>I know the DML to remove duplicate records...
>but now I need to just flag them in the table (...set NOTE = 'A DUPE !')
>
>Someone has the DML to do this ?
>Thanks
>
>Rob
>

No
You just need to set up a primary or unique key with an exceptions table associated to it, and that is it.
But I have the strange feeling you are dealing with a self-grown mess and you should better stop symptom-fighting asap.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 06 2002 - 14:53:08 CDT