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






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;
/








22.6.Labeled statement
22.6.1.Labeled statement
22.6.2.Labeled Block