SQLloader vs PL/SQL

From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Fri, 08 Jun 2001 14:06:03 -0500
Message-ID: <3B21221B.5215293E@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 - 14:06:03 CDT