Re: SLQ loader --> SQL updater
From: <.>
Date: Wed, 02 Jun 1999 09:13:23 GMT
Message-ID: <3754f399.3025903258_at_news.seinf.abb.se>
Date: Wed, 02 Jun 1999 09:13:23 GMT
Message-ID: <3754f399.3025903258_at_news.seinf.abb.se>
One solution could be to use SQL*Loader to insert into a temporary table and then have a stored procedure to update or insert into the main table.
On Wed, 02 Jun 1999 11:46:07 +0300, Ari Peltoniemi <ari.peltoniemi_at_hex.fi> wrote:
> HI
>
>Does anyone know is there a program like SQL Loader but instead of
>insert it should do an update. ?
>
>You could write a ctl file and then just run something like
>"sqlldr-updater CONTROL=foo.ctl DATA=etc.dat ...."
>Program should do an update on the the row instead of insert. If the row
>in the file does not exist in the database in that case it should do an
>insert. Otherwise the same functionality that SQL loader has....
>
>Thanks, Ari
>
Received on Wed Jun 02 1999 - 11:13:23 CEST