Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10243 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
Is sql microsoft?
Why is normalization important?
Why stored procedure is faster than query?
What is bulk compiling in pl/sql.?
What is sqlite format?
Write the alter statement to enable all the triggers on the t.students table.
Can we use join in subquery?
How can you load microsoft excel data into oracle? : aql loader
What does stand for in sql?
How subquery works in sql?
How to run sql*plus commands in sql developer?
What is function and procedure in pl sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is a primary key sql?
