How to insert data into two tables using single control file?
- 3 Answers
- 16709 Views
- Oracle, VTI, I also Faced
- E-Mail Answers
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 is count(*) from po_vendors(any table)?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to find the custom directory in front end?
tell me the scenarios of the independent in reports
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How can you achieve loose coupling in soa framework?
tell my any difficult situtation you solved in your experience in your company?
what are the prerequisites for costing transactions?
What do you understand by soa?
Can you differentiate between mediator and osb?
What is oracle soa suite?
what is the difference between request group and request security in oracle apps?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is oracle soa suite and what are its different components?
