Question

kettle如何抽取txt文件到oracle

我从oracle导出成txt文件,再用kettle把这个txt导入到oracle中一个表(跟源表一样) 出现字段类型错误,原来导出的txt字段类型在做表输入时已经变了 这可怎么是好啊

Answer 1

--取两个日期间的工作天数
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