What does fetching a cursor do?

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Explain table and field in sql?

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

What is parameter substitution in sql?

0 Answers  

---

How does a trigger work?

0 Answers  

---

What is varchar data type in sql?

0 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

What is the difference between microsoft access and sql server?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---