cursor with hold explain ?

1 Answers   Verizon,

---

can any one expalin check point with an example?

1 Answers  

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---

How does coalesce work?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What is the role of union all and union

0 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

Return code 100 means?

6 Answers   Cap Gemini,

---

Can you Average the Characters ?

3 Answers  

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---