SQL*Loader and csv files

From: Mike Roca, Jr. <roca_at_ultranet.com>
Date: Fri, 12 Nov 1999 15:39:54 -0500
Message-ID: <382C7B1A.31BC528C@ultranet.com>

Hi,

I'm attempting to get SQL*Loader to transfer a csv file into an Oracle database, however, I seem to be running into a bit of a problem.

I tried the following command:
sqlldr LOG=check.log, DATA=nscp.csv, USERID=vlad/math, CONTROL=nscp.ctl

Here's ctl file:
LOAD DATA

        INFILE 'nscp.csv'
        INTO TABLE nscp
        (dat          date "MM/DD/YY",
        cola          float external,
        colb          float external,
        colc          float external,
        cold          float external,
        larg          integer external)

The CSV file that I am trying to load into Oracle contains over 200 rows similar to the following:

1/12/99,64.500,71.500,64.000,71.063,6625200
1/11/99,68.938,70.500,64.500,64.500,6818800
1/8/99,61.938,65.563,61.875,64.750,4272300

I'd concider using the position keyword, but the variables are separated by commas rather than tabs, so the positioning is different for every row.

-Mike Received on Fri Nov 12 1999 - 14:39:54 CST