what is difference between decode and case function?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 17 Yes | 0 No |
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.
Is This Answer Correct ? | 3 Yes | 0 No |
What is a primary key sql?
what is the difference between granting and creating a view?
what is subquery? : Sql dba
Is sql better than access?
What pl/sql package consists of?
how to write date and time literals? : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
What is different between union and minus?
Explain select statements in sql?
What is rownum and rowid?
What is the difference between inner join and natural join?
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?