Re: SQLloader vs PL/SQL

You can use JSync 1.5 Data Migration Manager. The Migration Manager allows you to
map your source table at the column level to target table. In addition, you can define
your business logic using filters. With the filters you can add run stored procedures, query
tables and even run Oracle sequence.

It's real easy to use and it's all Java GUI.

Check it out at http://www.idera.com and there is a free trial download.

"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message news:3B21221B.5215293E_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 - 16:23:52 CDT