Re: SQL*Loader question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:49:40 GMT
Message-ID: <ti2c451i1bp8b8_at_beta-news.demon.nl>


"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message news:3B2121D6.C6FD4D9E_at_genomicfx.com...
>
> We have a need to upload, say a 6-fields data into a table with 8
> columns,
> with the data for additional 2 columns generated "on-the-fly" upon query
>
> and checking some criteria from the database (for example if a duplicate
>
> item ID is found, a flag will be generated with the itemID and a
> serial).
> It sounds like a PL/SQL routine but just wonder if there is any options
> available in SQLLoader for such needs (which one is easier?).
>
> Any hints/examples are appreciated!
>
> Zhiliang
>
>

Either create a trigger on the affected table or read the Oracle Server Utilities Manual. As you don't provide a version I can't provide an exact reference.
The manual documents you can calculate columns during load.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Jul 21 2001 - 23:49:40 CEST

Original text of this message