What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

What is an intent lock?

3 Answers  

---

What do you mean by cursor?

0 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

What is a synonym ?

2 Answers  

---

What is CHECK PENDING ?

5 Answers  

---