what is difference between decode and case function?
Answer Posted / 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 |
Post New Answer View All Answers
How do I remove sql developer from windows 10?
how would you enter characters as hex numbers? : Sql dba
what is the use of friend function? : Sql dba
Why is pl sql used?
What is sql architecture?
What is the difference between a subquery and a join?
What is data modelling in sql?
How to use transactions efficiently : transact sql
Is there a 64 bit version of ssms?
what is sp_pkeys? : Transact sql
what are aggregate and scalar functions? : Sql dba
What is a composite primary key?
How to know the last executed procedure?
How do I run a sql trace?
How can check sql version from command line?