Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help: delete the duplecated records
That is what I did, it will take for ever to finish, if you have more than a
few hundred records to delete.
Any other advice?
Thanks
"Valgaeren Dirk" wrote in message news:<8sf017$ef3$1_at_naxos.belnet.be>... >
what if
you use this : > > delete from my_table t1 > where rowid > (select rowid
from my_table t2
> where t2.my_field=t1.my_field); > >
Received on Mon Oct 16 2000 - 09:16:50 CDT