CREATE OR REPLACE FUNCTION func_datetime
RETURN VARCHAR2
IS
BEGIN
RETURN TO_CHAR(sysdate,
'yyyy"年"MM"月"DD"日" HH24"时"MI"分"SS"秒"');
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;