How do you load a CSV file into Oracle?
HOW TO LOAD .CSV FILE INTO ORACLE
Software/Hardware used:
Software/Hardware used:
ASKED:
October 19, 2009 5:40 PM
UPDATED:
October 19, 2009 8:04 PM
Answer Wiki:
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:
<pre>LOAD DATA
INFILE 'c:MY_FILE.csv'
INSERT INTO TABLE MY_TABLE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
FIELD_1,
FIELD_2,
FIELD_3
)</pre>
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
