Importing CSV

[CFProgrammer]

How to import a csv file. I know in sql server and Mysql you can use the bulk insert command.

Thanks In Advanced

Load Data infile...

 

[carp]

Use SQL*Loader.

 

[Shantha]

One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. Look at the following example:

sqlldr scott/tiger control=loader.ctl

This sample control file (loader.ctl) will load an external data file containing delimited data:
load data
infile 'c:\data\mydata.csv'
fields terminated by "," optionally enclosed by '"'
into table emp ( empno, empname, sal, deptno )

Hope this helps.
Talent is what you possess;
genius is what possesses you

 

[CFProgrammer]

Thanks Shantha,
I will give it a try. But I am loading this information through the web or passing the query in a sql statement through a datasource name.


Thanks...