If none of the WHEN value match with given value/expression, the ELSE values is returned. Simple case expression use for an equal condition on the given value or expression.The first WHEN value which is match with given value, return corresponding THEN value. A) Simple CASE statement: CASE expression WHEN this1 THEN that1 The CASE expression is a more flexible version of the DECODE function. Oracle support two flavors of CASE, simple and searched.
0 Comments
Leave a Reply. |