|
|
|
|
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
