Oracle: SQL Loader Example: load dates / specify date formats

create table tq84_sql_loader_5 (
   id    number not null,
   dt    date
);

load data
into table tq84_sql_loader_5
fields terminated by "|"
(
  id,
  dt      date "yyyy.mm.dd"
)

1|2012.12.12
2|2011.11.11
3|20101010

start create_table

host  sqlldr control=load_5.ctl userid=rene

select id, to_char(dt, 'dd.mm.yyyy') dt from tq84_sql_loader_5;

prompt
prompt  Note, record with "20101010" is also loaded
prompt

drop table tq84_sql_loader_5 purge;