SQL Loader

  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

  1. 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)

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