- 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;
|
|