Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

This script demonstrates GOTO

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.