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
What are file in oracle.
How can we import the data into a database using sql * loader?
What is oracle soa suite?
What is a flexfield? List out its types.
please send me forms, xml pulisher questions,answers
can we get profile values in report without using user exists is it possible how?
Tell me where we find the status of order information?
Can we create tables in apps schema?
How to move the one file from one instance to another instance? And your scripts also?
Do you know what are user profiles in apps. Any examples you can give?
How can a process be deployed in soa?
can we use look up type instead of a pofile option?or valueset?is it possible how?
what is the difference between request group and request security in oracle apps?
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.
What do you understand by soa?