What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is pragma exception and how, when, where us

5 Answers  

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

What is pls integer?

0 Answers  

---

---

What is synonyms?

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What is before and after trigger?

0 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

What is varchar sql?

0 Answers  

---