Oracle: SQL Loader - Example 11

create table tq84_trailing_nullcols (
   col_1  varchar2(10),
   col_2  varchar2(10),
   col_3  varchar2(10)
);

options (skip=1,silent=(all))
load data
infile 'some.dat'
into table tq84_trailing_nullcols
truncate
fields terminated by '|'
(
  col_1,
  col_2,
  col_3
)

options (skip=1, silent=(all))
load data
infile 'some.dat'
into table tq84_trailing_nullcols
truncate
fields terminated by '|'
trailing nullcols
(
  col_1,
  col_2,
  col_3
)

col_1|col_2|col_3
one|two|three
foo||

@create_table.sql

host sqlldr userid=rene/rene  control=without_trailing_nullcols.ctl

prompt Only one record loaded:
select * from tq84_trailing_nullcols;

host sqlldr userid=rene/rene  control=with_trailing_nullcols.ctl
prompt All (two) records loaded:
select * from tq84_trailing_nullcols;

drop table tq84_trailing_nullcols purge;