What is data control language?

0 Answers  

---

What is a column in a table?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

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 are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

What is on delete set null?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

---

I 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.

7 Answers   MTS,

---

What is the difference between a subquery and a join?

0 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

Is stored procedure faster than query?

0 Answers  

---