Hi,
following metalink documents may help you.
Note:65080.1 Using SQL To Delete Duplicate Rows In A Table
PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID
PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE
Murat
"Mark Warner"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
o.za> cc:
Sent by: Subject: removing duplicate entries
from a table
[EMAIL PROTECTED]
01/13/2003 07:35
PM
Please respond to
ORACLE-L
Hi List
Is there a tool for removing duplicate entries from a table - except that
the key field is not the same. I ran some data imports more than once and
was hoping someone could point me in the direction of a way to undo my
mistake.
Any help will be most appreciated
Thanks
Mark Warner
______________________________________________
"The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action
in reliance of the contents of this information is strictly prohibited
and may be unlawful. Absa is liable neither for the proper, complete
transmission of the information contained in this communication, nor
for any delay in its receipt, nor for the assurance that it is
virus-free."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Warner
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MURAT BALKAS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
