Labeled statement : Labeled statement « PL SQL Statements « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Statements
3. Labeled statement

SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
DECLARE
     v_Emergency_Warning VARCHAR2(50);
     v_Status NUMBER := 0;
BEGIN
     <<Emergency_Check>>

     BEGIN
          IF v_Status = 1 THEN
              DBMS_OUTPUT.PUT_LINE('call PANIC(); ');
              GOTO Emergency_Check;
 
          END IF;
     END;
END;
/