sqlldr userid=datamine/xxx control='filename'
OPTIONS (SKIP=1) load data infile 'loaddata.txt' into table test.table_name append fields terminated by ',' trailing nullcols ( categ_cd, prod_cd, recs, customers, ttl_amt )
OPTIONS (SKIP=1) load data infile 'xxx.txt' into table yyy.zzz append fields terminated by '\t' OPTIONALLY ENCLOSED BY '"' trailing nullcols ( col1, col2, col3 "to_date(:col3, 'YYYYMMDD')", col4 "to_date(:col4, 'MM/DD/YYYY HH12:MI:SS PM','NLS_DATE_LANGUAGE = American')", col5 char(320) )