what is difference between decode and case function?
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 is trigger point?
How to return an array from java to pl/sql?
What are the different operators available in sql?
What is a clob in sql?
What is sql deadlock?
how to drop an existing view in mysql? : Sql dba
Is mariadb nosql?
what is bcp? When is it used?
What is embedded sql in db2?
What are %type and %rowtype for?
What is sorting in sql?
Explain the difference in execution of triggers and stored procedures?
What does data normalization mean?
what is the use of double ampersand (&&) in sql queries?
How to fetch alternate records from a table?