Predefined exceptions: WHEN ZERO_DIVIDE : Predefined Exceptions « PL SQL « Oracle PL / SQL






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>
           
         
  








Related examples in the same category

1.If an ordering is applied, it occurs after the WHERE has been executed
2.NO_DATA_FOUND Exception
3.This script demonstrates user defined exceptions
4.This block illustrates the behavior of a predefined exception
5.This script demonstrates the scope of exceptions.