Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Sqlloader appending with duplicates
I thought of this method too... however, How can I write the script so that it can append and replace old records without using IFs (pure SQL)?
Ray
"Dave Matern" <dmatern_at_dtiservices.com> wrote:
> 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! =-----
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Aug 31 2000 - 16:03:10 CDT