PL/SQL Sequential Control

GOTO Statement

BEGIN
<<goto_label>>
-- Statement
...
GOTO goto_label;
...
END;

NULL Statement

BEGIN
-- sql statement
-- pl/sql statement
EXCEPTION
   WHEN OTHERS THEN
      NULL;
END;

Example

DECLARE
   v_count NUMBER;
BEGIN
   SELECT count(JOB_ID) INTO v_count FROM i_jobs WHERE job_name='DEVELOPER';
   IF v_count = 0 THEN
      GOTO insert_row; 
   ELSE
      GOTO null_row; 
   END IF;   
   <<insert_row>>
   INSERT INTO i_jobs VALUES (1,'DEVELOPER',10);
   <<null_row>>
   DBMS_OUTPUT.PUT_LINE('NULL statement example');  
   NULL;
END;