Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10099 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 run pl sql program in mysql?
What is the difference between sql and mysql?
Which kind of parameters cannot have a default value in pl sql?
how to start mysql server? : Sql dba
What are views in sql?
Explain ttitle and btitle.
Is it mandatory for the primary key to be given a value when a new record is inserted?
Enlist the data types that can be used in pl/sql?
What is sqlcommand?
How long will it take to learn pl sql?
What is the use of double ampersand (&&) in sql queries? Give an example
how can you see all indexes defined for a table? : Sql dba
Is id a reserved word in sql?
Which data type is a composite type?
what is sql in mysql? : Sql dba
