Why query optimization is needed?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

How do I run a sql trace?

0 Answers  

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

Can you sum a count in sql?

0 Answers  

---

What is trigger explain with example?

0 Answers  

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

What is index example?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---