Step 4
We should now create a SQL Loader control file by using any text editor. We will use VI editor for this purpose. Remember creating control file is mandatory in SQL Loader. In the control file we specify the format of the input file and target table name and other settings
Login to Linux machine as oracle user and start vi editor by typing the vi command along with control file name. Here we are using orders.ctl you can use any filename as per your choice
$vi orders.ctl
Then write the following contents
LOAD DATA
INFILE '/opt/oracle/test.csv'
BADFILE
'/opt/oracle/test.bad'
DISCARDFILE '/opt/oracle/test.dsc'
APPEND
INTO TABLE SCOTT.Orders
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED
BY '"' TRAILING NULLCOLS
(OrderID,CustomerID,EmployeeID,OrderDate
date "yyyy-mm-dd hh24:mi:ss",
RequiredDate date "yyyy-mm-dd
hh24:mi:ss",ShippedDate date "yyyy-mm-dd hh24:mi:ss",
ShipVia,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry)
After writing the above contents save the file and quit VI by pressing ESC and then :wq
