Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader and csv files

Re: SQL*Loader and csv files

From: Don Fraser <don_at_nrgdb.com>
Date: Mon, 15 Nov 1999 11:14:41 +1300
Message-ID: <942657230.610097@shelley.paradise.net.nz>


Its a while since I used sql loader but did you know you can use functions in the control? You can use decode to replace your commas with tabs. Best is to use the golden product set (shareware http://www.benthicsoftware.com). Mark has an excellent importer that supports a variety of delimiters. Also if you have MS Access you can set up a link table and just paste in rows which is easiest for small tables.

Don

Mike Roca, Jr. <roca_at_ultranet.com> wrote in message news:382C7B1A.31BC528C_at_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 Sun Nov 14 1999 - 16:14:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US