How to insert data into two tables using single control file?
Answer Posted / emmanuel - tcs
A Small changes in above control file
Add below insert stmt to above CTL File
Insert into Table Tab_name_1 -- This is for one table
Insert into Table Tab_name_2 -- This is for Second Table
First mention first table column and mention second table
columns
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
can we use look up type instead of a pofile option?or valueset?is it possible how?
can we get profile values in report without using user exists is it possible how?
How do you register report in oracle apps?
What are the different components you should consider while defining a responsibility in oracle apps?
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 instead of trigger in where we will use?
How can we import the data into a database using sql * loader?
Can u give the Documentation of Custom.pll in oracle apps
what are the different transaction clauses in AR?
how to print multi lay outs,muti currency,muti language in xml publisher
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What are do's and dont's of Interface?
tell me the scenarios of the independent in reports
In hierarchical structure of a database? we have write query from where we should start?
what is the differences between internal requisition and internal sales order?