Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to update datas in a script ?
All right, thank you for your response.
Can PL/SQL make updates and how does it work ?
Philippe.
Milton Rodriguez a écrit dans le message
<3969F739.D8CE9408_at_telcel.net.ve>...
>You must use PL/SQL.
>
>Philippe Wolf wrote:
>
>> 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 Mon Jul 10 2000 - 00:00:00 CDT