Re: How to update datas in a script ?

Hi Philippe,

It depends on how you want the job to be done. If you would like it to be an automated (scheduled) job, because you know the new file will be at a location at a given time, I'd suggest you write some code in PL/SQL. However if it is something that occurs only once a month, you'd probably could do it by hand with de SQL*Loader. Looking at the logic you described the PL./SQL procedure would be very easy to build. I made a little procedure that does the same thing in about 20 lines of code. You could use the utl_file utility to read the textfile. The difficulty of the procedure will depend on how the data is represented within the textfile. If you need a code example, let me know...

HTH, Bastiaan Schaap
Oracle web development,
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31355411711

Philippe Wolf <~~pwolf_at_ecritel.net> wrote in message news:8kcpbj$56h$1_at_news5.isdnet.net...
> 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