How to insert data into two tables using single control file?
Answer Posted / bobbyiiit
Using "When"
we use "When" condition to load data into multiple tables.
Syntax:
Load Data infile '&1'
Insert into table table1
(
.
.
.
.
)
Insert into table table2
when <condiation>
(
.
.
.
);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you understand by soa?
How is choreography different from orchestration?
Explain what are the tables of auto invoice?
what are the prerequisites for costing transactions?
How can you achieve loose coupling in soa framework?
tell my any difficult situtation you solved in your experience in your company?
List the types of flexfield?
What is oracle soa suite?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
How can we import the data into a database using sql * loader?
Tell me how to debug the report?
Tell me where we find the status of order information?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Do you know where we can check the status of po?
pls send me out bound code of supplers,site,bankiformation code pls as soon as