--
-- blog.watashii.com
--
-- usage: sqlldr userid=user/password@DB_INSTANCE_NAME control=import.ctl log=import.log
-- notes: imports CSV data into an Oracle database table
--
OPTIONS (SKIP=1)
LOAD DATA 
BADFILE 'import.bad'
APPEND
INTO TABLE T_IMPORTED_DATA
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
    SERIAL         INTEGER EXTERNAL               NULLIF SERIAL        = BLANKS,
    TITLE          CHAR                           NULLIF TITLE         = BLANKS,
    PUBLISH_DATE   DATE "DD/MM/YYYY HH24:MI:SS"  NULLIF PUBLISH_DATE  = BLANKS,
    DESCRIPTION    CHAR(400)                      NULLIF DESCRIPTION   = BLANKS
)