kettle抽取oracle数据库数据
仰望星空的我
仰望星空,脚踏实地。
展开
-
oracle中varchar2字段存入blob字段及blob转成varchar2
CREATE OR REPLACE FUNCTION C2B (b IN CLOB default empty_clob()) RETURN BLOB -- typecasts BLOB to CLOB (binary conversion) IS res BLOB; b_len number := dbms_lob.getlength(...转载 2018-08-01 17:42:06 · 2145 阅读 · 0 评论 -
Oracle通过过程定期取数
---通讯助手扣费 execute immediate 'select count(1) from user_tables where table_name = upper(''ZJ201101300006_txzs_kf'')' into vv_datacnt; if ( vv_datacnt >0 ) then execute immediate 'drop table ...转载 2018-08-02 16:50:42 · 257 阅读 · 0 评论