Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus one/two

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 13 13:33:20 2013

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create table me(id number,name varchar(20));

Table created.

SQL> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>notepad one.ctl

C:\Documents and Settings\Administrator>sqlldr one/two one.ctl


SQL*Loader: Release 10.2.0.1.0 - Production on Tue Aug 13 13:35:46 2013

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


C:\Documents and Settings\Administrator>exit

SQL> select * from me;

no rows selected.

Satheesh,1000
Aravind,2000
Mohan,3000
Ravi,4000
Magi,5000