Re: removing duplicate entries from a table

From: MURAT BALKAS <murat.balkas_at_o2.net.tr>
Date: Mon, 13 Jan 2003 10:04:57 -0800
Message-ID: <F001.0052DFC4.20030113100457@fatcity.com>

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"                                                                                                    
                      <margarete_at_absa.c        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      o.za>                    cc:                                                                                     
                      Sent by:                 Subject:  removing duplicate entries from a table                                       
                      root_at_fatcity.com                                                                                                 
                                                                                                                                       
                                                                                                                                       
                      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: margarete_at_absa.co.za

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: ListGuru_at_fatcity.com (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: murat.balkas_at_o2.net.tr

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: ListGuru_at_fatcity.com (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).

Received on Mon Jan 13 2003 - 12:04:57 CST