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.

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

Why do we need cursors in pl sql?

0 Answers  

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

Why use stored procedures?

0 Answers  

---

What are all the ddl commands?

0 Answers  

---

Will truncate release space?

0 Answers  

---

Is sql injection illegal?

0 Answers  

---

How many types of indexes are there in sql?

0 Answers  

---

What is embedded sql what are its advantages?

0 Answers  

---

What does rownum mean in sql?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---