-- EXAMPLE ADAPTED from ORACLE DOCUMENTATION 
-- 
-- to load this,
-- 1. make sure that empltemp table *has* been created; note that,
--    since APPEND is used below, it need not be empty, in this case.
-- 2. create a file with these contents named empltemp_data2.ctl
-- 3. make sure empltemp_data2.dat exists before you attempt to run this.
-- 3. type at the UNIX prompt (WITHOUT the two dashes, and
--    replacing xx with YOUR Oracle username):
--
--       sqlldr userid=xx control=empltemp_data2.ctl log=empltemp_data2.log

LOAD DATA
   INFILE 'empltemp_data2.dat'      -- after INFILE, can put the name of an
                                    -- input data file --- preferably
                                    --  ending in .DAT?)

   APPEND                           -- put if adding data to a non-empty table
   INTO TABLE empltemp
   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
   (empl_num, empl_last_name, job_title, mgr, hiredate, salary,
         commission, dept_num)
-- end