How to insert data into two tables using single control file?

Answers were Sorted based on User's Feedback



How to insert data into two tables using single control file?..

Answer / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

Is This Answer Correct ?    10 Yes 1 No

How to insert data into two tables using single control file?..

Answer / 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

How to insert data into two tables using single control file?..

Answer / 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

More Oracle Apps Technical Interview Questions

When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,


In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,


what is difference between po_headers_all and po_headers

5 Answers   Deloitte, Wipro,


in GL module specifing org_id or not?

1 Answers  


what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,






What are the Standard Reports and Forms in HRMS?

0 Answers  


How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,


Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,


How is choreography different from orchestration?

0 Answers  


What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,


tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,


Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)