Re: Sqlloader appending with duplicates

You could write a script to create a temporary table, load the data into the temporary table using SQL*Loader, run a PL/SQL script to do the insert/update based on the existing data and once complete drop the temporary table. Crude...but effective.

Dave Matern
DotCom Technologies, Inc.

<vdragonz_at_my-deja.com> wrote in message news:8olso5$kl6$1_at_nnrp1.deja.com...
> Hi all,
>
> I'm using SqlLoader to load my data into my database. I've to use the
> APPEND method because I've already got something in the database.
> However, in my new data, there are also some records that are updates
> of the old records in the database. Is there any method to do the
> append and the record updates at the same time? or do you have any
> good idea to solve this problem?
>
> Thank you very much !
>
> Ray
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Aug 31 2000 - 10:37:29 CDT