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 are the different components of soa suite?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is the differences between internal requisition and internal sales order?
Can you differentiate between mediator and osb?
testing tools?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Explain oracle apps architecture.
tell my any difficult situtation you solved in your experience in your company?
What is sca and how is it useful?
do you know is it possible to run the interface without using oracle apps?
tell me the scenarios of the independent in reports
Can you explain the difference between architecture followed in 10g & 11g?
Which oracle apps version you are very confident in?
Do you know what are user profiles in apps. Any examples you can give?
Is soa a part of oracle fusion middleware?