What is query optimization in sql?

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

What are reports usually used for?

0 Answers  

---

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

What is data control language (dcl)?

0 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

What is compiled query?

0 Answers  

---