Re: SQL*Loader Question

Hi Ashraful Islam,

Thank you for your reply.

I agree with your solution. My only option is to use UTL_FILE package.

Thanks again.

allan

Ashraful Islam wrote in message <6btk84$jh9$1_at_winter.news.erols.com>...
>If you want to UPDATE existing data one way to do it would be to read the
>data using TEXT_IO package in Oracle form and updating the record through
>SQL update command.
>
>
>Allan Lee wrote in message <6brfgt$l6k_at_bgtnsc02.worldnet.att.net>...
>>Hi,
>>
>>I'm able to insert new data using SQL*loader & it's fast especially using
>>the direct path load.
>>
>>Can SQL*Loader be used to update or change an existing entry in a table?
 If
>>not, what's a fast way to update a record with data coming from a
>>comma-separated file. Is using UTL_FILE package a way to go? I'm afraid
>>using the package will be slow.
>>
>>Thanks in advance.
>>
>>allan
>>
>>
>>
>
>
Received on Thu Feb 12 1998 - 00:00:00 CST