Re: How to update datas in a script ?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/07/11
Message-ID: <20000711.3310600@p200.nodomain>#1/1

	Step 1.  Use SQL*Loader to load all of the new rows
	Step 2.  Load the contents of the bad file (the SQL*Loader discards) 
into another table
	Step 3.  Delete the rows in the original table that are also in the 
table created in Step 2
	Step 4.  Insert the contents of the table created in Step 2 into the 

original table

	Use SQL*Loader for steps one and two
	Use either SQL*Plus or PL/SQL or ... for steps 3
	Use SQL*Plus for Step 4.


>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/10/00, 10:19:05 AM, "Philippe Wolf" <~~pwolf_at_ecritel.net> wrote regarding How to update datas in a script ?:

> Hi,
 

> I receive every day a file containing data to add
> to an existent database, on Oracle 8i.
> The probleme is that I may update certain rows, so
> that it's not a replacement.
> Must I use PL/SQL, SQL Loader, java...?
> A solution could be to read the file, line by line,
> see if the record exists, update it if yes, or insert it if not,
> but it could be long with some thousands or more of records
> to inspect.
> Could any one tells me how to do ?
> Thank's for any help.
 

> Philippe.
Received on Tue Jul 11 2000 - 00:00:00 CDT