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

SQL*Loader: Release 8.1.6.0.0 - Production on Mon Oct 7 08:49:20 2002

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

Commit point reached - logical record count 10
<hr>
this is control file
<hr>
C:mag>type emp.ctl
load data
infile 'testz.txt'
replace
into table test_z
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
A char "ltrim(:a,'0')"
)
C:mag>type testz.txt
"1234"
"01234"
"001234"
"0001234"
"0000001"
"0000000"
"asdf"
"234"
"234"
"234"
<hr>
SQL> ed
Wrote file afiedt.buf

  1* select rownum,a from test_z
SQL> /

    ROWNUM A
---------- ----------
         1 1234
         2 1234
         3 1234
         4 1234
         5 1
         6
         7 asdf
         8 234
         9 234
        10 234

10 rows selected.