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;