Beefy Boxes and Bandwidth Generously Provided by pair Networks
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??


in reply to Re^2: Best method to load a csv file.
in thread Best method to load a csv file.

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://415702]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2024-04-25 06:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found