Why we use stored procedure instead of query?

0 Answers  

---

How do I get sql certification?

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

how to create a test table in your mysql server? : Sql dba

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

What are inner outer left and right joins in sql?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

What is the need of merge statement?

0 Answers  

---

How do you rank data in sql?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---