Mega Code Archive
Categories
/
Oracle PLSQL Tutorial
/
PL SQL Statements
An Example of the GOTO Statement
SQL> DECLARE 2 v_Status NUMBER := 1; 3 BEGIN 4 IF v_Status = 1 THEN 5 GOTO mybranch; 6 ELSE 7 v_Status := 1; 8 END IF; 9 <
> 10 NULL; 11 END; 12 / PL/SQL procedure successfully completed. SQL>