– CASE is a expression
– DECODE is a function
- CASE expression is ANSI SQL Statement
- DECODE is specific to Oracle Syntax
- CASE syntax contains WHEN and THEN
- DECODE will not have this
- CASE allow expressions or Scalar Sub query Expressions inside the CASE statement
- DECODE won't allow expressions inside the DECODE function
No comments:
Post a Comment