SQL *Loader

what is sql*Loader and what is it used for?
sql*loader is a bulk loader utility used for moving data from external files into oracle database. its syntax is similar to that of the DB2 load utility

c:\sqllr\sqlldr.bat

@echo ON
@echo "LOADING TABLE...."
sqlldr userid=scott/tiger@omkara control=C:\sqlldr\sqlldr.CTL log=C:\sqlldr\sqlldr.log bad=c:\sqlldr\sqlldr.bad
pause
Exit;

c:\sqlldr\sqlldr.ctl --control file

LOAD DATA
INFILE 'C:\sqlldr\sqlldr.txt'
REPLACE INTO TABLE t
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY ' " '
TRAILING NULLCOLS
(
INSUREDID
)
NOTE:
for raw data in sqlldr.txt file other wise append raw data same .ctl at last line
as below
LOAD DATA
INFILE 'C:\sqlldr\sqlldr.txt'
REPLACE INTO TABLE t
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY ' " '
TRAILING NULLCOLS
(
INSUREDID
)662575
662669
659726
661462
665099
[or]
c:\sqlldr\sqlldr.txt

662575
662669
659726
661462
665099