How would you pass hints to the sql processor?

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  

---

what are the demerits of sql?

1 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

what is try_catch block in procedure

0 Answers  

---

Which certification is best for sql?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

What is the difference between joins?

0 Answers  

---

How many sql databases can you have on one server?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---