Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dupes
Why dont you write a little plsql using a cursor to select all the duplicates. You can use the count attribute of the cursor to delete all the rows and even decide to leav the first one if required.
regards
Richard Garrett Parallax Solutions.
Bruce Bristol wrote in article <335ADC4B.7415_at_ix.netcom.com>...
> I have two tables, a base and an incremental with the same layout.
>
> They somehow now have duplicate rows.
>
> I want to find the dupes and ultimately, delete them from the
> incremental table.
Received on Fri Apr 25 1997 - 00:00:00 CDT