Sqlloader utility

Step1:create  a control file

Example.ct

Load data Infile ’load.dat’(datafile path location here) Into table schemaname.tablename Append or replace Fields terminated by ‘,’ (id,number)(column name here)

Step 2:

Save this in the name of load.dat

12,kannan 13,arun 14,gh

Step 3:

Give the command in sql

Create table loader(id number(23),name varchar2(34));

Table created

Step 4:exit the sql prompt

Issue the command like

C:\>sqlldr user/password control=controlfile path log=logfile path

Data inserted into table..