Oracle: SQL Loader example: Insert comma separated data

Create destination table

create table tq84_sql_loader_2 (
  field_1       varchar2(10),
  field_2       number
);

Control file

load data
infile 'load_2.dat' "str '\r\n'"
insert
into table tq84_sql_loader_2
fields terminated by ','
(
  field_1      char,
  field_2      integer external
)

The data

one,1
two,2
fifty,50
eighty-eight,88
one hundred,100
fifteen,15

Load the data

$ sqlldr control=load_2.ctl userid=rene/password@ora.server.xy

See also