SQL Loader in Oracle

oracle  used to load the contents of the data file on the operating system into the oracle database . 

sql loader, , inside tell sql loader started sql loader After the policy of loading data . 

     Create a new studentdataload.ctl file , write  

Load data infile ' studentdata.txt ' into table studentinfo fields terminated by ' | ' (num,name,classnum,tel,address)

     and then started in the console Span style= "Font-family:times New Roman; Background-color:inherit; " >sql loader, write user name password ( load data with ), . 

Sqlldr Userid=username/[email protected] Control=studentdata.ctl Log=load.log

Using the SQL Loader method is much simpler .

SQL Loader in Oracle