SQL> BEGIN
2 CASE TRUE
3 WHEN (1 > 3) THEN
4 dbms_output.put_line('One is greater than three.');
5 WHEN (3 < 5) THEN
6 dbms_output.put_line('Three is less than five.');
7 WHEN (1 = 2) THEN
8 dbms_output.put_line('One equals two.');
9 ELSE
10 dbms_output.put_line('Nothing worked.');
11 END CASE;
12 END;
13 /
Three is less than five.
PL/SQL procedure successfully completed.
SQL>
|