Sql loader is a bulk loader utility used for moving DATA from external files into the oracle database.

Sql loader supports various load formats, selective loading, and multi-tables loads.

1. Conventional --The conventional path loader essentially loads the data by using STANDARD ‘insert’ statement.
2. Direct -- The direct path loader (direct = TRUE) by possess of logic involved with that, and loads directly in to the oracle data files.

EX:- My data.csv file

1001, “scott tiger”,1000,40

1002,”gvreddy”,2345,50

Load data

Infile ‘c:datamydata.csv’

insert Into table emp FIELDS terminated by “,” optionally enclosed by‘”’

(empno, empname,sal,deptno)

>sqlldr scott/tiger@vis control=loader.ctl log= gvlog.log bad=gvbad.bad discard=gvdis.dsc .

Sql loader is a bulk loader utility used for moving data from external files into the oracle database.

Sql loader supports various load formats, selective loading, and multi-tables loads.

EX:- My data.csv file

1001, “scott tiger”,1000,40

1002,”gvreddy”,2345,50

Load data

Infile ‘c:datamydata.csv’

insert Into table emp Fields terminated by “,” optionally enclosed by‘”’

(empno, empname,sal,deptno)

>sqlldr scott/tiger@vis control=loader.ctl log= gvlog.log bad=gvbad.bad discard=gvdis.dsc .