template sql loader

-- template for sql loader control file

LOAD
DATACHARACTERSET UTF8
INFILE 'infile.txt'
BADFILE 'badfile.bad'
DISCARDFILE 'dscfile.dsc'
APPEND
INTO TABLE MITABLA
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"'
(   FIELD1,
    FIELD2 "TO_NUMBER(:FIELD2,'99999.9999')",
    FIELD3 FILLER,
    FIELD4,
    FIELD5 FILLER)