There's more than one way to do things | |
PerlMonks |
Re^3: Best method to load a csv file.by RiotTown (Scribe) |
on Dec 17, 2004 at 17:19 UTC ( [id://415702]=note: print w/replies, xml ) | Need Help?? |
I'd suggest a shell script that would fire off a SQL*Loader process for each of the different file layouts. From documentation on SQL*Loader: To load data from multiple datafiles in one SQL*Loader run, use an INFILE clause for each datafile. Datafiles need not have the same file processing options, although the layout of the records must be identical. Write a control file for each of the 5 or 6 different data file layouts then make sure to reference that in your calling statement.
In Section
Seekers of Perl Wisdom
|
|