Case and Decode

What is the difference between Case and Decode?
In what situation we can use Case and Decode

Questions by mail2das.ashok

Showing Answers 1 - 1 of 1 Answers

veerisetty

  • Jun 18th, 2008
 

DECODE works with expressions which are scalar values.
CASE can work with predicates and subqueries in searchable form:
CASE is an ANSI standard, where as Decode is proprietary for Oracle
We can use expressions as part of case statements, where as Decode looks for a value.
regards
veerisetty

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions