It can be done with the help of <a href="http://download.oracle.com/docs/cd/B14117_01/server.101/b10825/part_ldr.htm#i436326">Sql*Loader</a>
It has many parameters and options, but you could use a simple control file like this:
INSERT INTO TABLE MY_TABLE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
Then you could call Sql*Loader like this:
<pre>sqlldr my_user@my_database control=my_control_file.ctl</pre>
The documentation includes many examples as well.
Last Wiki Answer Submitted: October 19, 2009 8:04 pm by carlosdl63,535 pts.