First page Back Continue Last page Image

A Stored Procedure CASE Statement Alternative

CASE

WHEN boolean_expression THEN

code_to_run_if_match;

WHEN boolean_expression THEN

code_to_run_if_match;

ELSE

code_to_run_if_no_match;

END CASE;

There is a CASE statement option that allows you to code it using boolean expressions like an if statement

TRUE

FALSE

TRUE

FALSE