Oracle:哪位大侠了解Oracle的ERP的看板管理?
发布网友
发布时间：2022-04-14 01:10
共1个回答
热心网友
时间：2022-04-14 02:39
SELECT COUNT(*) INTO vn
FROM (SELECT vod + ROWNUM - 1 RN
FROM DUAL
CONNECT BY ROWNUM <= vnd - vod)
WHERE TO_CHAR(RN, 'D') BETWEEN 2 AND 6;
--返回数字
RETURN vn;
--异常判断并返回-1
EXCEPTION
WHEN OTHERS THEN
RETURN -1;
END fun_get_workdays;
然后select id,fun_get_workdays(begin_date date, end_date date) from table
