SQL Loader – Control File For Variable Length Data File(CSV)

by admin

Control File to read CSV File

OPTIONS (SKIP=1) 
LOAD DATA
INFILE '/home/applmgr/dataFiles/empData.csv'
append INTO TABLE emp
FIELDS TERMINATED BY ","
(
 EMPNO    ,
ENAME    ,
JOB      ,
MGR      ,
HIREDATE    date "DD-MON-YYYY",
SAL      ,
COMM     ,
DEPTNO   
)

Data File

EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO
100,KING1,PRESIDENT,,17-NOV-1981,5000,,10

Place the files in the below location (You have to consider the directories according to your directory structure and make sure to change the data file location in control file)

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: SQLLoader