Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10148 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the benefits of triggers?
what is the difference between truncate and drop statements? : Sql dba
what is denormalization. : Sql dba
what is uncommittable transactions? : Transact sql
How to use distinct and count in sql query? Explain
In what condition is it good to disable a trigger?
what is normalization? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is a .db file?
Does truncate table reset auto increment?
What is procedure and function in sql?
How do I truncate a word?
Define union, minus, union all, intersect ?
What is java sql package?
What is package in pl sql with an examples?
