Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10244 Views
- I also Faced
- E-Mail Answers
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 start sql profiler?
What mean sql?
What is trigger in sql? Explain
What is the primary key?
List the different type of joins?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
How can we store rows in PL/SQL using array?
What are reports usually used for?
what is a trigger in mysql? : Sql dba
what is the difference between char and varchar data types? : Sql dba
What is dml statement?
What is the purpose of the primary key?
what are local and global variables and their differences? : Sql dba
How long will it take to learn pl sql?
What is meant by truncate in sql?
