SQL Loader

SQL

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;

Leave a Reply

Your email address will not be published. Required fields are marked *