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

how to customize the report,please tell me customization steps

5 Answers   Accenture,

---

How do u customize the Reports?

1 Answers  

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

---

what is difference between API and Interface?

2 Answers   Infogain,

---

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

---

Attribute data types?

2 Answers  

---

wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,

---

how i can create temporary table?

1 Answers   Zensar,

---

What do you understand by a set of books?

0 Answers  

---