Live ORACLE

DROP TABLE employees_temp CASCADE CONSTRAINTS PURGE;


CREATE TABLE employees_temp
 AS
 SELECT employee_id,
        salary,
        commission_pct
 FROM   employees;



DECLARE
 sal_calc  NUMBER(8,2);
BEGIN
 INSERT INTO employees_temp
 VALUES     (301,
             2500,
             0);
 SELECT salary
          / commission_pct
 INTO   sal_calc
 FROM   employees_temp
 WHERE  employee_id = 301;
 INSERT INTO employees_temp
 VALUES     (302,
             sal_calc
               / 100,
             .1);
EXCEPTION
 WHEN zero_divide THEN
   NULL;
END;
/

DECLARE
 sal_calc  NUMBER(8,2);
BEGIN
 INSERT INTO employees_temp
 VALUES     (303,
             2500,
             0);
 BEGIN -- sub-block begins
   SELECT salary
            / commission_pct
   INTO   sal_calc
   FROM   employees_temp
   WHERE  employee_id = 301;
 EXCEPTION
   WHEN zero_divide THEN
     sal_calc := 2500;
 END; -- sub-block ends
 INSERT INTO employees_temp
 VALUES     (304,
             sal_calc
               / 100,
             .1);
EXCEPTION
 WHEN zero_divide THEN
   NULL;
END;
/  

Continuing after an Exception Is Raised