OPTIONS (SKIP=0) LOAD DATA BADFILE "Load_bad.bad" TRUNCATE INTO TABLE LOAD_DATA FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS { NAME char , AGE char, ID char, REASON char "REPLACE(REPLACE(:REASON , '"', ''), '"', '')", INTEREST char "REPLACE(REPLACE(:INTEREST, '"', ''), '"', '')", EXPERIENCE char }