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

veerisetty

 Profile Answers by veerisetty Questions by 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 OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty

Answer Question  Select Best Answer