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 do I clear the screen in sql plus?

0 Answers  

---

How many joins can you have in sql?

0 Answers  

---

What is database migration?

0 Answers  

---

What is sql lookup?

0 Answers  

---

Write a query to display the current date in sql?

0 Answers  

---

What are operators available in sql?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

What are the different sql languages?

0 Answers  

---

Explain Connect by Prior?

2 Answers  

---

What are tables in sql?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---