关于LR连接oracle时报未在本地计算机上注册“OraOLEDB.Oracle.1的问题
你好，我看你之前问过关于LR连接oracle时报未在本地计算机上注册“OraOLEDB.Oracle.1的问题，请问怎么解决的
第1个回答 2015-05-28
--取两个日期间的工作天数
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本回答被网友采纳
相似回答
