Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Remove duplicates again

Remove duplicates again

From: xiaomh <xiaomh_at_hotmail.com>
Date: Tue, 13 Mar 2001 16:37:00 -0500
Message-ID: <98m3us$eh5$1@news.gov.on.ca> 






I want to import 100000 entries to my database. Each entry has mutiple
columns, suppose 10 columns. There are some duplicates in them(sometimes
according to (column1, column2), sometimes according to (column5, column6)).



How can I keep entries imported to database are unique on (column1, column2)
and (column5, column6).



What's the best way to remove them(duplicates)?



Thanks in advance!
Received on Tue Mar 13 2001 - 15:37:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US