-- (comment by J. Walker, example modified from her example)
--the reason you put the 'trailing nullcols' is because you are
--indicating to the loader that there is a value to be put there
--and the value is a sequence as satisfied by the name of your
--sequence put in double quotes.  It must be put in double quotes

-- to load this,
-- 1. make sure that painter table *has* been created; it need not be
--    empty, since APPEND is used below
-- 2. create a file with these contents named painter.ctl
-- 3. make sure that painter.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=painter.ctl log=painter.log

LOAD DATA
INFILE 'painter.dat'
APPEND
INTO TABLE painter
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(ptr_num "painter_seq.nextval", ptr_lname, ptr_fname)