Database Reference
In-Depth Information
Figure 24.14
Splitting Results
Using an IF
Statement.
Search Condition
. A search condition with no selector. This form of
the CASE statement is very similar to the IF statement shown in Fig-
ure 24.14.
Selector and Expression
. A selector with an expression result for the
selector.
24.7.1.2.1
CASE Statement Search Condition
To demonstrate the use of the CASE statement, we can show a modifica-
tion of the PL/SQL block we created to demonstrate use of the IF state-
ment. This CASE statement example will use the search condition version
of the CASE statement. Change the IF statement code of the previous
example. See the result in Figure 24.16.