Oracle BULK Loader

SQL *Loader (sqlldr) is a bulk loader utility to load data from external files into Oracle database. To use this utility, a control file is required which specifies how data should be loaded into the database and a data file is required which specifies what data should be loaded.  A sample control file is as follows:

LOAD DATA

INFILE "datafile"

APPEND INTO TABLE "tablename"

FIELDS TERMINATED BY "separater"

("list of all attribute names to be loaded")

 

A sample data file can be of following form:

 

1,'Gaurav'

2, 'ABC'

3,'PQR'