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  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

What is a Procedure ?

3 Answers  

---

Can we join two tables without common column?

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

Why we use triggers in mysql?

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

Enlist some predefined exceptions?

0 Answers  

---