Posted on 2014-09-05
I have a master detail two tables called as Master and detail relation ( x and y), I am using sql loader
x (empno, empname, ) and Y as ( empno, sal, deptno) and a data into a csv file. I need some assistance in writing the ctl file , i saw an example but with one table how to write a ctl with two table with a master detail relation
need assistance on this
into table x
fields terminated by "," optionally enclosed by '"'
( empno, empname)