Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10116 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 is csv? : Sql dba
What is sql server and ase?
Do we need to rebuild index after truncate?
Write the command to remove all players named sachin from the players table.
How much does sql certification cost?
What is fmtonly in sql?
What is denormalization in a database?
Why cross join is used?
How are sql commands classified?
what are sequences
What is query execution plan in sql?
What are tables and fields?
How can we find duplicate records in a table?
Can a primary key be a foreign key?
How do I kill a query in postgresql?
