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  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

what is oracle database ? : Sql dba

0 Answers  

---

Which normal form is best?

0 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

---

What are the different types of dbms?

0 Answers  

---

what is global table

7 Answers   iFlex,

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

What is embedded sql with example?

0 Answers  

---

Is oracle sql free?

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

What is raw datatype in sql?

0 Answers  

---