a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,
z,y,x,w,v,u,t,s,r,q,p,o,n,m,l,k,j,i,h,g,

LOAD DATA
INFILE flat_file.dat
INTO TABLE table1
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(col1 POSITION(1),col2,col3,col4,col5,col6,col7,col8,col9,col10)
INTO TABLE table2
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(fil1 FILLER POSITION(1), fil2 FILLER, fil3 FILLER, fil4 FILLER, fil5 FILLER,
fil6 FILLER, fil7 FILLER, fil8 FILLER, fil9 FILLER, fil10 FILLER,
col1, col2, col3, col4, col5, col6, col7, col8, col9, col10)

SCOTT@orcl_11gR2> CREATE TABLE table1
  2    (col1   VARCHAR2(4),
  3  	col2   VARCHAR2(4),
  4  	col3   VARCHAR2(4),
  5  	col4   VARCHAR2(4),
  6  	col5   VARCHAR2(4),
  7  	col6   VARCHAR2(4),
  8  	col7   VARCHAR2(4),
  9  	col8   VARCHAR2(4),
 10  	col9   VARCHAR2(4),
 11  	col10  VARCHAR2(5))
 12  /

Table created.

SCOTT@orcl_11gR2> CREATE TABLE table2
  2    (col1   VARCHAR2(4),
  3  	col2   VARCHAR2(4),
  4  	col3   VARCHAR2(4),
  5  	col4   VARCHAR2(4),
  6  	col5   VARCHAR2(4),
  7  	col6   VARCHAR2(4),
  8  	col7   VARCHAR2(4),
  9  	col8   VARCHAR2(4),
 10  	col9   VARCHAR2(4),
 11  	col10  VARCHAR2(5))
 12  /

Table created.

SCOTT@orcl_11gR2> HOST SQLLDR scott/tiger CONTROL=test.ctl LOG=test.log

SCOTT@orcl_11gR2> SELECT * FROM table1
  2  /

COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 COL10
---- ---- ---- ---- ---- ---- ---- ---- ---- -----
a    b    c    d    e    f    g    h    i    j
z    y    x    w    v    u    t    s    r    q

2 rows selected.

SCOTT@orcl_11gR2> SELECT * FROM table2
  2  /

COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 COL10
---- ---- ---- ---- ---- ---- ---- ---- ---- -----
k    l    m    n    o    p    q    r    s    t
p    o    n    m    l    k    j    i    h    g

2 rows selected.

SCOTT@orcl_11gR2>