Let us see how to transfer CSV file data in an Oracle database table. A CSV (Comma-separated value) file basically stores tabular data (numbers and text) in plain-text form. It is a common and simple file format used by many applications. Pre-requisites : Oracle database 10g Express Edition with *SQLPlus, Oracle Data Integrator (build version 11.1.1.0.7) First, you need to create your .csv file. Open notepad and write the following! EMPLOYEE_ID,FIRSTNAME,LASTNAME 1 ,Dean,Winchester 2 ,John,Winchester 3 ,Sam,Winchester Save the file with filename as employee.csv Next we need to create a corresponding table in Oracle to store this information. Open *SQLPlus and login with your credentials. Create table using following command! create table csv_test(empid int primary key, firstname varchar( 30 ), lastname varchar( 30 )); The data in this table will come from the .csv file that we will load usin...