Re: SQL*Loader Question

From: Yuji Shimono <shimsoft_at_foxinternet.net>
Date: 1998/02/11
Message-ID: <34E1EA94.41449A6B@foxinternet.net>#1/1

It seems to me that in the control file you can specify REPLACE to replace existing data in the table.

Allan Lee wrote:

> 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 Wed Feb 11 1998 - 00:00:00 CST