load multiple csv in different tables in oracle using sql loader.
suppose i have 3 tables:
create table t1(name varchar2(10),id numeric);
create table t2(age numeric,zone varchar2(10));
create table t3(address varchar2(20),nationality varchar2(10));
now we have 3 csv's
csv1:
'abc',1;
'def',2;
'xyz',3;
csv2:
12,'north';
15,'south';
18,'west';
csv3:
'delhi','indian';
'bangalore','indian';
'mumbai','indian';
now using sql loader(How to write in Control file) i want to load csv1 to table t1,csv2 to table t2,csv2 to table t3;
Thanks and Regards,
Nageshwar Reddy Porla.