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;
刘轶鹤