Simple Oracle Function which Returns Yes or No
CREATE OR REPLACE FUNCTION isStudentInArmy(p_location IN VARCHAR(255),
p_age IN LONG)
RETURN CHAR
IS
isArmyMen CHAR(1);
BEGIN
SELECT CASE
WHEN BodyType == 'Well Built and Strong' THEN 'Y'
ELSE 'N'
END INTO isArmyMen
FROM tblMens
WHERE Location = p_location AND
Age = p_age;
RETURN isArmyMen;
END isStudentInArmy;