SQL>
SQL> DECLARE
2 v_TestVar NUMBER := 1;
3 BEGIN
4 <<MyCase>>
5 CASE v_TestVar
6 WHEN 1 THEN DBMS_OUTPUT.PUT_LINE('One!');
7 WHEN 2 THEN DBMS_OUTPUT.PUT_LINE('Two!');
8 WHEN 3 THEN DBMS_OUTPUT.PUT_LINE('Three!');
9 WHEN 4 THEN DBMS_OUTPUT.PUT_LINE('Four!');
10 END CASE MyCase;
11 END;
12 /
One!
PL/SQL procedure successfully completed.
SQL>
|