what is difference between decode and case function?
- 2 Answers
- 9367 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
How does one use sql*loader to load images, sound clips and documents? : aql loader
When is the explicit cursor used ?
What is normalization? How many normalization forms are there?
What is #table in sql?
What is a table partition?
How do you use a while loop in pl sql?
Are stored procedures faster than dynamic sql?
How is data stored in sql?
Can a table contain multiple primary key’s?
How do I make sql search faster?
How long will it take to learn pl sql?
Is inner join same as self join?
how many tables will create when we create table, what are they? : Sql dba
What is the purpose of a secondary key?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
