How to insert data into two tables using single control file?
- 3 Answers
- 16693 Views
- Oracle, VTI, I also Faced
- E-Mail Answers
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
What is instead of trigger in where we will use?
Can u give the Documentation of Custom.pll in oracle apps
what is pay run id ?
do you know is it possible to run the interface without using oracle apps?
What are do's and dont's of Interface?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What are the different components you should consider while defining a responsibility in oracle apps?
How can a process be deployed in soa?
what are the balancing segments in AR?
what is the differences between internal requisition and internal sales order?
Plz anybody send me Technical specification for AP Interface
What do you understand by soa?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Tell me how to find the custom directory in front end?
How can we import the data into a database using sql * loader?
