Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Sunday, June 04, 2006

boolean return type from function

How to get boolean return type from function?

CREATE OR REPLACE FUNCTION F_Is_Even(i_number IN NUMBER)
RETURN BOOLEAN
AS
/*
DECLARE
b1 BOOLEAN;
v1 VARCHAR2(10);
BEGIN
b1 :=F_Is_Even(10);
IF (b1) THEN
v1 :='TRUE';
ELSE
v1 :='FALSE';
END IF;
dbms_output.put_line(v1);
END;


*/
v1 VARCHAR2(10);
v2 BOOLEAN;
BEGIN
SELECT DECODE(MOD(i_number,2),0,'TRUE',1,'FALSE','FALSE') INTO v1 FROM dual;
IF v1='TRUE' THEN
v2 :=TRUE;
ELSE
v2 :=FALSE;
END IF;
RETURN v2;
END;
/

0 Comments:

Post a Comment

<< Home