SQL>
SQL>
SQL> PROMPT ** GOTO
** GOTO
SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('BEGINNING OF BLOCK');
3
4 GOTO l_Last_Line;
5
6 DBMS_OUTPUT.PUT_LINE('GOTO didn''t work!');
7 RETURN;
8 <<l_Last_Line>>
9 DBMS_OUTPUT.PUT_LINE('Last Line');
10 END;
11 /
BEGINNING OF BLOCK
Last Line
PL/SQL procedure successfully completed.
|