What are the types of keys?

0 Answers  

---

How do I run a sql trace?

0 Answers  

---

Why truncate is faster than delete?

0 Answers  

---

Is hadoop a nosql?

0 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,

---

how to escape special characters in sql statements? : Sql dba

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

What is dense_rank?

0 Answers  

---

How does left join work in sql?

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 is the meaning of disabling a trigger?

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---