DECLARE
AGE NUMBER:=&AGE;
SATHYA EXCEPTION;
BEGIN
IF(AGE<10) THEN
RAISE SATHYA;
ELSE
DBMS_OUTPUT.PUT_LINE('ELIGIBLE TO JOIN IN THE SCHOOL');
END IF;
EXCEPTION
WHEN SATHYA THEN
RAISE_APPLICATION_ERROR(-20000,'AGE SHOULD NOT BE LESS THAN 10 YEARS');
END;
AGE NUMBER:=&AGE;
SATHYA EXCEPTION;
BEGIN
IF(AGE<10) THEN
RAISE SATHYA;
ELSE
DBMS_OUTPUT.PUT_LINE('ELIGIBLE TO JOIN IN THE SCHOOL');
END IF;
EXCEPTION
WHEN SATHYA THEN
RAISE_APPLICATION_ERROR(-20000,'AGE SHOULD NOT BE LESS THAN 10 YEARS');
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.