Answer / durga

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely

union all : it would combine the two query and displays then
as its duplicates.

Answer / veki

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1

union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.

what is repeting frame?

3 Answers   TCS,

---

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,

---

what is difference between API and Interface?

2 Answers   Infogain,

---

how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,

---

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

---

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---

what is inbound and outbound interface?

2 Answers  

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---