Tuesday, 16 February 2016

ZERO DIVIDE EXAMPLE

DECLARE
A NUMBER:=&A;
B NUMBER:=&B;
C NUMBER;
BEGIN
C:=A/B;
DBMS_OUTPUT.PUT_LINE('THE RESULT IS'||C);
EXCEPTION
WHEN ZERO_DIVIDE THEN
DBMS_OUTPUT.PUT_LINE('THE DENOMINATOR SHOULD NOT BE ZERO');
END;

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.