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


Please Help Members By Posting Answers For Below Questions

what are the different transaction clauses in AR?

1604


What do you understand by concurrent programs?

619


What do you understand by soa and what are the benefits of using this architecture?

619


How can you achieve loose coupling in soa framework?

726


tell my any difficult situtation you solved in your experience in your company?

1868






what is pay run id ?

1712


do you know is it possible to run the interface without using oracle apps?

654


What are the different components you should consider while defining a responsibility in oracle apps?

647


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2130


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

638


In oracle application how do you debug or trace errors?

639


Which oracle apps version you are very confident in?

707


testing tools?

1754


In hierarchical structure of a database? we have write query from where we should start?

1708


What does appl_top directory contain?

650