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

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

Are you familiar with internet architecture of oracle apps 11i?

0 Answers  

---

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

---

what are the different calculation columns available in reports?

1 Answers  

---

---

Can you define an erp system?

0 Answers  

---

FLEX FIELDS?

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,

---

what is aim methodolozy

1 Answers  

---

What r the type Models in the system parameters of the report?

1 Answers  

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

How to generate XML Report with out using rdf?

6 Answers   BirlaSoft, Patni, UST,

---