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.

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

what is meant by Table space?

2 Answers  

---

Can u give the Documentation of Custom.pll in oracle apps

0 Answers  

---

Do you know where we can check the status of po?

0 Answers  

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---

in ap_terms table what data will be stored

1 Answers  

---

Matrix Report: Simple, Group above, Nested

1 Answers  

---

Can u define operating units inplace of inventory?

2 Answers  

---

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---