Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between decode and case function?
- 2 Answers
- 10000 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 is the difference between an inner join and an outer join?
How do we use distinct statement? What is its use?
explain the delete statements in sql
Does a user_objects view have an entry for a trigger?
How do you modify a column in sql?
How do I truncate a sql log file?
What are stored procedures used for?
How do you write a subquery?
Why do we need a foreign key?
How do I create an index in word?
What is sql basics?
What are the parts of a sql statement?
Write the alter statement to enable all the triggers on the t.students table.
Write a sql query to convert all character to uppercase after hypen.
What is nosql vs sql?
