what is difference between decode and case function?
- 2 Answers
- 9366 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
how to install mysql? : Sql dba
How do you get column names only for a table (sql server)?
What is sql and how does it work?
Does view store data in sql?
Is ms sql is free?
What is the use of index in sql?
How can I see all tables in sql?
Define select, insert, create, delete, update, drop keywords
What is a dynamic query?
What are the possible values for the boolean data field?
How many sql statements are used?
Why is the cursor important?
What can I use instead of union in sql?
What are keys in sql?
What are analytic functions in sql?
