oracle@mutation#desc mutation scott.mytable

Table:scott.mytable
           Name                      Null?    Type
           ------------------------- -------- ------------------------
    1      ID                                 NUMBER
    2      NAME                               VARCHAR2(10)
    3      NAME_ORIGINAL                      VARCHAR2(10)
    4      CODE                               VARCHAR2(10)
    5      CODE_ORIGINAL                      VARCHAR2(10)

oracle@mutation#query mutation scott.mytable

no rows selected

oracle@mutation#cat myctl.ctl
LOAD DATA
INFILE 'myinfile.csv'
append
INTO TABLE mytable
fields terminated by ';' optionally enclosed by '"' trailing nullcols
(id,
name,
code,
name_original ":name",
code_original ":code")
oracle@mutation#cat myinfile.csv
1;A;AAA
2;B;BBB
3;C;CCC
oracle@mutation#sqlldr userid=scott/tiger control=myctl.ctl

SQL*Loader: Release 9.2.0.4.0 - Production on Fri Nov 18 09:33:23 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 3
oracle@mutation#query mutation scott.mytable

        ID NAME       NAME_ORIGI CODE       CODE_ORIGI
---------- ---------- ---------- ---------- ----------
         1 A          A          AAA        AAA
         2 B          B          BBB        BBB
         3 C          C          CCC        CCC