Write a Control file, say emp.ctl
load data
options(direct=true)
insert
into table emp
fields terminated by ',' optionally enclosed by '"' TRAILING NULLCOLS
(
c1 DECIMAL EXTERNAL,
c2
)
Execute SQL*Loader as below.
sqlldr userid=user/pass@db data=reports.csv control=emp.ctl
If you always want to refresh the table with your data completely. TRUNCATE
the table and then load.
SQL*Loader
is great utility that provide numerous options for performance. Kindly go through the documentation about DIRECT and CONVENTIONAL loading.
There's something called EXTERNAL tables, that might interest you as well. They use the flat file for the table data.