1. Create a file and give it a name (Ex: data.txt)
2. Insert some valuable data in it. Here we have insert the following things into data.txt

1,Subrina

2,Manik

3,Rahi

4,Rashed

5,Upol

6,Hasan

3. Create a SQL Loader control file and give it a name. Here we have create a control file which name is LOADER.CTL

load data

infile ‘c:\data.txt’

into table info

fields terminated by ‘,’

(id,name)

4. SQL>CREATE TABLE info(id number,name varchar(30));      [Under Scott user]
5. C:\>sqlldr userid=scott/abc#1 CONTROL=c:\LOADER.CTL
6. SELECT * FROM info;