load data
infile 'S:\TPStats\BT Download\118247\2008\December\ERD_20081204.csv'
into table DAILYIMPORTTABLE
fields terminated by "," optionally enclosed by '"'
(text_col1 FILLER,
text_col2 FILLER,
CALLEDSERVICE,
text_col3 FILLER,
NOM_DATE "TO_DATE(:NOM_DATE,,'DD/MM/YYYY HH24:Mi:SS')",
TIME "TO_DATE(:TIME,'HH24:Mi:SS')",
Duration,
text_col4 FILLER,
text_col5 FILLER,
CLI,
BTID,
text_col6 FILLER,
text_col7 FILLER,
text_col8 FILLER,
text_col9 FILLER,
text_col10 FILLER,
text_col11 FILLER,
text_col12 FILLER)

NOM_DATE "TO_DATE(:NOM_DATE,,'DD/MM/YYYY HH24:Mi:SS')",

NOM_DATE "TO_DATE(:NOM_DATE,'DD/MM/YYYY HH24:Mi:SS')",