Re: SQL*Loader Question

From: Ashraful Islam <ashraful_at_erols.com>
Date: 1998/02/11
Message-ID: <6btk84$jh9$1@winter.news.erols.com>#1/1

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