Re: SQL*Updater ??
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: davidsharples@xxxxxxxxx
- Date: Thu, 16 Feb 2006 23:47:26 +0100
... 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@xxxxxxxxx
<mailto:knightjck_work@xxxxxxxxx>> 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
- Follow-Ups:
- Re: SQL*Updater ??
- From: Jonathan Knight
- References:
- Re: Allowing users to execute shell scripts without seeing password
- From: David Sharples
- SQL*Updater ??
- From: Jonathan Knight
- Re: SQL*Updater ??
- From: David Sharples
Other related posts:
- » SQL*Updater ??
- » Re: SQL*Updater ??
- » Re: SQL*Updater ??
- » Re: SQL*Updater ??
using external tables and simple sql might be worth looking at
On 2/16/06, *Jonathan Knight* <knightjck_work@xxxxxxxxx <mailto:knightjck_work@xxxxxxxxx>> 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.- Re: SQL*Updater ??
- From: Jonathan Knight
- Re: Allowing users to execute shell scripts without seeing password
- From: David Sharples
- SQL*Updater ??
- From: Jonathan Knight
- Re: SQL*Updater ??
- From: David Sharples