-- sqlldr userid=uwclass/uwclass control=c:\demo\demo12.ctl log=c:\temp\demo12.log

OPTIONS (ERRORS=100, SILENT=(FEEDBACK))
LOAD DATA
INFILE *
REPLACE
INTO TABLE dept
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(recno RECNUM, deptno CONSTANT "XX", dname, loc, tdate SYSDATE)

BEGINDATA
RESEARCH,"SARATOGA"
"ACCOUNTING",CLOVELAND
"ART",SALEM
FINANCE,"BOSTON"
"SALES",ROCHESTER
"INT'L","SAN FRANCISCO"