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'
Posts
