Create a file and give it a name (Ex: data.txt)
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
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)
SQL>CREATE TABLE info(id number,name varchar(30)); [Under Scott user]
C:\>sqlldr userid=scott/abc#1 CONTROL=c:\LOADER.CTL
SELECT * FROM info;