LOAD DATA 
INFILE 'c:\scott_data' 
append
INTO TABLE emp
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
TRAILING NULLCOLS 
(empno,ename,sal,deptno )