SQL*Loader question

From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Fri, 08 Jun 2001 14:04:54 -0500
Message-ID: <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 Received on Fri Jun 08 2001 - 21:04:54 CEST

Original text of this message