December 2002
Intermediate to advanced
928 pages
85h 29m
English
CASE
WHEN expression = value_expr THEN
action;
[WHEN expression = value_expr THEN
action; . . .]
[ELSE
action;]
END CASE;Unlike the CASE statement, the CASE expression does not have a switch expression; instead, each WHEN clause has a complete Boolean expression. The first matching WHEN clause is executed and control passes to the next statement following the END CASE.