Predefined exceptions: WHEN ZERO_DIVIDE
SQL> SQL> --Predefined exceptions SQL> set serverout on; SQL> SQL> DECLARE 2 v_num1 NUMBER := 5; 3 v_num2 NUMBER := 0; 4 myResult NUMBER; 5 BEGIN 6 myResult := v_num1/v_num2; 7 DBMS_OUTPUT.PUT_LINE('The quotient is '||TO_CHAR(myResult)); 8 EXCEPTION 9 WHEN ZERO_DIVIDE THEN 10 DBMS_OUTPUT.PUT_LINE('You cannot divide by zero'); 11 END; 12 13 / You cannot divide by zero PL/SQL procedure successfully completed. SQL>