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>
|