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.

Explain what are the tables of auto invoice?

0 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

How to link modules in apps

3 Answers   Zensar,

---

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

---

What is a flexfield? List out its types.

0 Answers  

---

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

What is count(*) from po_vendors(any table)?

0 Answers  

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---

can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,

---

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

---

oracle apps architecture

1 Answers   TCS,

---

what is difference between procedure and function

5 Answers   E Logic,

---