Answer / neha sinha

1)Performance wise Case is good.

2)Case is easy to understand and debug.

3)Case is ANSI stranded and Decode is property of oracle.

4) We can use Decode only in SQL but we can use Case any
where like Function/procedure.

5)Decode can be use only for continuous data not for range
value. but case can be use for range value and it allowed
operator like ">" "between" also.

Answer / shiva kumar

Case functions are of two types
1. SIMPLE CASE(Equivalent to DECODE)
2. SEARCHED CASE

1.SIMPLE CASE is equivalent to DECODE in performance.The
only difference is it is ANSI Standard where as DECODE
function is designed by oracle.

2.SEARCHED CASE is more powerful then DECODE.Using SEARCHED
CASE we can evaluate multiple conditions,range evaluation.

What does pl sql developer do?

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---

What is memory optimized table?

0 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What does select count (*) mean in sql?

0 Answers  

---

How delete a row in sql?

0 Answers  

---

Will truncate release space?

0 Answers  

---

how to use like conditions? : Sql dba

0 Answers  

---

What are the different types of constraints?

0 Answers  

---

What is a variable in sql?

0 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---