What is the maximum number of triggers,can apply to a single table?

2 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?

2 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

what is a cursor? : Sql dba

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

When to use inner join and left join?

0 Answers  

---

Define the select into statement.

0 Answers  

---

What is sql deadlock?

0 Answers  

---

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---