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



LOAD DATA

INFILE *

APPEND

INTO TABLE emp

FIELDS TERMINATED BY ","

OPTIONALLY ENCLOSED BY '"'

(empno, ename, job, mgr, hiredate DATE "DD-Month-YYYY",

sal, comm, deptno CHAR TERMINATED BY ':',

projno, loadseq SEQUENCE(MAX,1))



BEGINDATA

9782,"Clark",Manager",7839, 09-June-2000, 2572.50,, 10:101

9839,"King","President", , 17-November-1999, 5500.00,,10:102

9934,"Miller","Clerk",7782, 23-January-2001, 920.00,, 10:102

9566,"Jones","Manager",7839, 02-April-2001, 3123.75,, 20:101

9499,"Allen","Salesman",7698, 20-February-2001, 1600.00, 300.00, 30:103

9654,"Martin","Salesman",7698, 28-September-2000, 1312.50, 1400.00, 30:103

9658, "Chan", "Analyst", 7566, 03-May-1999, 3450,, 20:101