Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10122 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
What are synonyms in sql?
How many rows can sqlite handle?
What is difference between nchar and nvarchar?
Explain what is a view?
what is the bond code in materialized view?
What is coalesce sql?
What is the difference between having and a where in sql?
Can we use ddl commands in pl sql?
How much does a sql dba make? : SQL DBA
Is sql a programming?
what is top in tsql? : Transact sql
what are the advantages and disadvantages of views in a database? : Sql dba
what happens if you no create privilege in a database? : Sql dba
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Are pl sql variables case sensitive?
