truncate table t_export_test;

SCOTT@orcl_11g> create table test (name varchar2(10),phone number)
  2  /

Table created.

LOAD DATA
INFILE test.txt
INSERT
INTO TABLE test
FIELDS TERMINATED BY ';'
TRAILING NULLCOLS
(name,
phone
)

Vetri;12345
vel;302303
sudha;123456

SCOTT@orcl_11g> HOST sqlldr scott/tiger control=test.ctl log=test.log

SCOTT@orcl_11g> select * from test
  2  /

NAME            PHONE
---------- ----------
Vetri           12345
vel            302303
sudha          123456

SCOTT@orcl_11g> 

SQL*Loader: Release 11.1.0.6.0 - Production on Thu Aug 14 09:42:00 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Control File:   test.ctl
Data File:      test.txt
  Bad File:     test.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table TEST, loaded from every logical record.
Insert option in effect for this table: INSERT
TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
NAME                                FIRST     *   ;       CHARACTER            
PHONE                                NEXT     *   ;       CHARACTER            


Table TEST:
  3 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                  33024 bytes(64 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:             3
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Thu Aug 14 09:42:00 2008
Run ended on Thu Aug 14 09:42:01 2008

Elapsed time was:     00:00:00.94
CPU time was:         00:00:00.07