LOAD DATA
INFILE 'errors.csv'
INSERT INTO TABLE errors
FIELDS TERMINATED BY ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
ID,
mno INTEGER EXTERNAL,
usid,
ad_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
ad_user,
re_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
re_user)

LOAD DATA
INFILE 'errors.csv'
INSERT INTO TABLE errors
FIELDS TERMINATED BY ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
ID,
mno INTEGER EXTERNAL,
usid,
ad_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
ad_user,
rv_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
rv_user)

LOAD DATA
INFILE 'errors.csv'
INSERT INTO TABLE errors
FIELDS TERMINATED BY ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
ID,
mno INTEGER EXTERNAL,
usid,
ad_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
ad_user,
rv_date to_Date('DY,DD MON YYYY,hh24:mi:ss TZD'),
rev_user)

Record 1: Rejected - Error on table "NMDB"."ERRORS", column AD_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected


Table "NMDB"."ERRORS":
  0 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

SQL*Loader-350: Syntax error at line 14.
Expecting "," or ")", found "to_timestamp".
          ad_date to_timestamp('DY,DD MON YYYY,hh24:mi:ss TZD'),
                   ^

SQL*Loader-282: Unable to locate character set handle for character set ID (2000).