Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10103 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 to write pl sql program in mysql command prompt?
How do I install sql?
What are the sql commands?
What does the acronym acid stand for in database management?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is sql architecture?
What is restrict in sql?
How do I install microsoft sql?
Can we update views in sql?
How do I view an execution plan in sql?
Explain what is a column in a table?
Explain foreign key in sql?
Explain how exception handling is done in advance pl/sql?
How to prepare for oracle pl sql certification?
What is sqlerrd?
