Search This Blog

Thursday, December 19, 2013

Oracle PL Number Evaluation Problem

Give me your feedback for this code mentioned below.
SET SERVEROUTPUT ON;
DECLARE
V_MYAGE NUMBER;
BEGIN
DBMS_OUTPUT.PUT_LINE('V_MYAGE : '||V_MYAGE);
IF V_MYAGE < 10 THEN
DBMS_OUTPUT.PUT_LINE('1-I am a child');
ELSE
DBMS_OUTPUT.PUT_LINE('1-I am NOT a child');
END IF;
IF V_MYAGE > 10 THEN
DBMS_OUTPUT.PUT_LINE('2-I am NOT a child');
ELSE
DBMS_OUTPUT.PUT_LINE('2-I am a child');
END IF;
END;

No comments: