What are sql triggers used for?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Why use subqueries instead of joins?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

How do you go back in sql?

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

What is the maximum number of columns in sql table?

0 Answers  

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

what are local and global variables and their differences? : Sql dba

0 Answers  

---