Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Updater ??

Re: SQL*Updater ??

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 16 Feb 2006 23:47:26 +0100
Message-ID: <43F500FE.7000703@roughsea.com>


... To be more precise external table + MERGE.

Stéphane Faroult

David Sharples wrote:

> define large and are they simple inserts or updates?
>
> using external tables and simple sql might be worth looking at
>
>
> On 2/16/06, *Jonathan Knight* <knightjck_work_at_yahoo.com
> <mailto:knightjck_work_at_yahoo.com>> wrote:
>
> My current project requires a largish daily update to
> a database table. Is there any way to do this with
> SQL*Loader? If not, I'm looking at loading to a
> temporary table and kicking off a PL/SQL job to update
> the affected records.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 16 2006 - 16:47:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US