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 -> Re: Remove duplicates

Re: Remove duplicates

From: JIK <JIK_at_HOME.COM>
Date: Tue, 13 Mar 2001 03:30:12 -0000
Message-ID: <tar524o2r47776@corp.supernews.com>

My suggestion would be to put a primary key on the table (the primary key being what makes each record unique), and let import reject the duplicates.

JIK xiaomh wrote:
>
>
> I want to import 10000 entries to my database. There are some duplicates
 in
> them.
>
> What's the best way to remove them(duplicates)?
>
> Thanks in advance!
>
>

--
Posted via CNET Help.com
http://www.help.com/
Received on Mon Mar 12 2001 - 21:30:12 CST

Original text of this message

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