oracl 函数示例 FUNCTION 必须有返回值

CREATE OR REPLACE FUNCTION func_datetime
RETURN VARCHAR2
IS
BEGIN
  RETURN TO_CHAR(sysdate,
   'yyyy"年"MM"月"DD"日" HH24"时"MI"分"SS"秒"');

END;

CREATE OR REPLACE FUNCTION func_isHoliday(p_date DATE)
RETURN INTEGER
AS
  v_weekday INTEGER := -1;
BEGIN
  SELECT TO_CHAR(p_date, 'D') INTO v_weekday FROM DUAL;
  IF v_weekday-1 > 5 THEN
    RETURN 1;
  ELSE
    RETURN 0;
  END IF;
END;

CREATE OR REPLACE FUNCTION func_getinfo
(empid    NUMBER,position OUT VARCHAR2)
  RETURN VARCHAR2 AS
  name employees.name%type;
BEGIN
  SELECT t.name, p.postname
     INTO name, position
     FROM employees t, post p
   WHERE t.position = p.postid
     AND t.id = empid;
  RETURN name;
END;