How to find odd and even number in pl sql oracle ? #sqlqueries @oracle-tutorials

How to find odd and even number in pl-sql oracle ? #sqlqueries @Oracle Worm-Free Oracle Tutorials

Query for odd and even number in pl sql oracle

SET SERVEROUTPUT ON
/
CREATE OR REPLACE PROCEDURE FINDEVENODD(
NO INT
)
AS
BEGIN
IF MOD(NO,2)=0 THEN
DBMS_OUTPUT.PUT_LINE(NO||' '||' IS EVEN NUMBER');
ELSE
DBMS_OUTPUT.PUT_LINE(NO||' '||'IS ODD NUMBER');
END IF;
END;
/
EXECUTE FINDEVENODD(90);
EXECUTE FINDEVENODD(91);

#sqlqueries #oracletutorial #sqlqueries #oracle