Re: SQL*Loader question
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