Payables and Cash Management - EBS (MOSC)

MOSC Banner

load multiple csv in different tables in oracle using sql loader.

edited Jan 28, 2015 4:47AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center