Importing data from Comma Seperated Value (CSV) files

GNU/Linux Desktop Survival Guide
by Graham Williams

1. Create a table:

SQL$>$ desc test; Name Null? Type ------------------------- -------- -------------- PIN NUMBER BALANCE NUMBER

2. Create controlfile.txt:

load data infile 'data.csv' into table test fields terminated by "," optionally enclosed by '"' ( PIN, BALANCE )

3. From the oracle server, run:

sqlldr username/password@ control=controlfile.txt

4. Check the result:

SQL> select * from test; PIN BALANCE ------- ----------- 1 1000 2 23456 3 -1