-- EXAMPLE ADAPTED from ORACLE DOCUMENTATION
--
-- to load this,
-- 1. make sure that empltemp table *has* been created, but is *empty*
-- 2. create a file with these contents named empltemp_data1.ctl
-- 3. type at the UNIX prompt (WITHOUT the two dashes, and
--    replacing xx with YOUR Oracle username):
--
--       sqlldr userid=xx control=empltemp_data1.ctl log=empltemp_data1.log     

LOAD DATA
     INFILE *

     INTO TABLE empltemp

     FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

     (empl_num, empl_last_name, job_title, mgr, hiredate, salary,
         commission, dept_num)

     BEGINDATA
7369,Smith,Clerk,7902,17-Dec-90,800.00,,20
"7499","Allen","Salesman","7698","20-Feb-91",1600.00,300.00,"30"
"7521",Ward,"Salesman",7698,"22-Feb-91",1250.00,500.00,30