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)

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

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>
(
.
.
.
);

What is a value set? List its various types.

0 Answers  

---

Is it possible to do purchase order without requisition?

8 Answers  

---

how will u do documentation

2 Answers  

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,

---

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

in ap_terms table what data will be stored

1 Answers  

---

oracle apps architecture

1 Answers   TCS,

---

why r u transer the data base tables to flat file and what is use

2 Answers  

---