CASE statement (PL/SQL)

The CASE statement executes a set of one or more statements when a specified search condition is true. CASE is a standalone statement that is distinct from the CASE expression, which must appear as part of an expression.

There are two forms of the CASE statement: the simple CASE statement and the searched CASE statement.