oracle@mutation#desc mutation scott.mytable

Table:scott.mytable
           Name                      Null?    Type
           ------------------------- -------- ------------------------
    1      ID                                 VARCHAR2(30)

oracle@mutation#cat myctl.ctl
LOAD DATA
INFILE 'mydata.data'
append
INTO TABLE mytable
fields terminated by ',' optionally enclosed by '"' trailing nullcols
(id "case :id
        when 'r1'then 'another record'
        when 'r2'then 'someother record'
        else 'somejunkdata'
        END")

oracle@mutation#cat mydata.data
r
r1
r2
x
oracle@mutation#sqlldr userid=scott/tiger control=myctl.ctl

SQL*Loader: Release 9.2.0.4.0 - Production on Mon Dec 5 21:19:28 2005

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

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

ID
------------------------------
somejunkdata
another record
someother record
somejunkdata

oracle@mutation#