Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10149 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha sinha
1)Performance wise Case is good.
2)Case is easy to understand and debug.
3)Case is ANSI stranded and Decode is property of oracle.
4) We can use Decode only in SQL but we can use Case any
where like Function/procedure.
5)Decode can be use only for continuous data not for range
value. but case can be use for range value and it allowed
operator like ">" "between" also.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Write a unique difference between a function and a stored procedure.
What is #table in sql?
How do you add a column to a table?
What does trigger mean in psychology?
How can you select unique records from a table?
What is a pl/sql block?
How do I run a sql script?
How do I access sql anywhere database?
how to create a new view in mysql? : Sql dba
Describe different types of general function used in sql?
What is pessimistic concurrency control? : Transact sql
what are the authentication modes in sql server? : Sql dba
What are conditional predicates?
Is a secondary key the same as a foreign key?
how do you know the version of your mysql server? : Sql dba
