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.

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

How does stored procedure reduce network traffic?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

What is cascade in sql?

0 Answers  

---

What is the life of an sql statement?

0 Answers  

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

Can we use pl sql in mysql?

0 Answers  

---

What is multiple partition?

0 Answers  

---

What is query syntax?

0 Answers  

---