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;
