Oracle BASE64加密解密函数应用

Oracle BASE64加密解密函数应用 

由于字符集 问题 导致乱码

加密示例

select utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw('刘轶鹤'))) from dual

结果是 5YiY6L226bmk

解密示例

select

convert((utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('5YiY6L226bmk')))), 'ZHS16GBK', 'UTF8') from dual;

刘轶鹤

select utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('5YiY6L226bmk'))) from dual;

刘轶鹤