Re: Any free script/utility for bulk loading using SQLLoader

Subrahmanyam Arya wrote:
> Hi there,
>
> No i meant if anybody has written any unix shell scripts that wrapped
> up inside it the commands for invoking sqlloader and have passed the
> necessary details for the bulkloader on the fly dynamically
>
> -thx,
> avsrk

I guess you can write code that is MUCH smarter than my code.

I can't begin to know how to write code that automagically contains the "necessary details" to load an arbitrary set of tables containing an arbitrary collection of data fields from one or more flat files that could contain any number of data elements separated by an unknown delimiter.

The best I have done is to write custom Perl scripts that were specifically written to handle KNOWN flat file formats and loading KNOWN tables & KNOWN columns.

HTH & YMMV HAND! Received on Thu May 29 2003 - 02:23:30 CEST