Oracle form developer哪里下载
我的一个作业里需要formdeveloper用这东西,在哪里下载,我现在已经装了Oracle9i...
我的一个作业里需要form developer用这东西,在哪里下载,我现在已经装了Oracle 9i
展开
2个回答
展开全部
--取者改芹两个日期间的工作天数首毕
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
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
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询