How to do a Data load in oracle
Loading a bulk amount of data from a source like excel file to data base is described below. To do this we need 3 files. 1) A control file (.ctl) 2) A schell script (.ksh) 3) Script doing dataload(insert or update script) Control file (.ctl) Usually data load is doing like initially we load data to a staging(temporary)table.From there we load data into our target tables.So in control file we specify the fields in staging table which are going to accept the incoming values. A control file will simply specify the order of database table fields which will be filled with data from the source file.An example of control file is given below. Let's say EMPLOYEE is a table which temporarly stores incoming data.Save this in .ctl file format. eng:Load_Data.ctl LOAD DATA REPLACE INTO TABLE EMPLOYEE FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( emp_name "TRIM(:employee_name)" , emp_age ...