C:>type test.ctl
LOAD DATA
INFILE 'test.dat'
replace
into  table test446 FIELDS TERMINATED BY ',' optionally enclosed by '"'
(
id,
name char "reverse(:name)"
)

----------------------------------------------------------------------

C:>type test.dat
1,"magvive"
2,"someone"
3,"nobody"

----------------------------------------------------------------------

C:>sqlldr userid=mag/mag control=test.ctl

----------------------------------------------------------------------

SQL*Loader: Release 8.1.6.0.0 - Production on Wed Jan 15 14:47:35 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 2
Commit point reached - logical record count 3

----------------------------------------------------------------------

C:>sqlplus mag/mag

SQL*Plus: Release 8.1.6.0.0 - Production on Wed Jan 15 14:47:43 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> select * from test446;

        ID NAME
---------- ----------
         3 ydobon
         1 evivgam
         2 enoemos

SQL>