oracle字符集过程内转换

最新推荐文章于 2024-07-25 11:08:25 发布

回到未来望过去

最新推荐文章于 2024-07-25 11:08:25 发布

阅读量1.4k

点赞数

文章标签： oracle cast_to_varchar2

本文链接：https://blog.csdn.net/viviliving/article/details/82705047

版权

主要使用UTL_RAW.CAST_TO_RAW函数

源端提出

create or replace view kc21_dex as

select akb020,aac001,akc190,aab001,aka130,akc192,UTL_RAW.CAST_TO_RAW(akc193) akc193,akc194,UTL_RAW.CAST_TO_RAW(akc195) akc195,UTL_RAW.CAST_TO_RAW(akc196) akc196,akc197,UTL_RAW.CAST_TO_RAW(aae011) aae011,aae036,akc198,akc199,akc200,aka101,UTL_RAW.CAST_TO_RAW(ckc016) ckc016,ckb070,ckc230,ckc231,ckb071,cka011,ckc232,ckb072,ckc233,akc021,aae073,aka131,akc191,ckc044,ckc119,ckc120,ckc121,ckc122,akc240,akc263,aka151,akb021,ckc017,ckc125,aka120,akc087,ckc130,akc089,zkc002,akc090,add002 from kc21;

目标端导入

select akb020,aac001,akc190,aab001,aka130,akc192,utl_raw.cast_to_varchar2(akc193) akc193,akc194,utl_raw.cast_to_varchar2(akc195) akc195,utl_raw.cast_to_varchar2(akc196) akc196,akc197,utl_raw.cast_to_varchar2(aae011) aae011,aae036,akc198,akc199,akc200,aka101,utl_raw.cast_to_varchar2(ckc016) ckc016,ckb070,ckc230,ckc231,ckb071,cka011,ckc232,ckb072,ckc233,akc021,aae073,aka131,akc191,ckc044,ckc119,ckc120,ckc121,ckc122,akc240,akc263,aka151,akb021,ckc017,ckc125,aka120,akc087,ckc130,akc089,zkc002,akc090,add002 from kc21_dex@to_120001 WHERE (add002 IS NULL OR add002='0')) loop