oracle加密解密
将手机号加密为base64格式的密文:
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(#{mobile})))
解密:
utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('密文')))
plsql工具配置多用户:
用户名/密码@ip:端口号/连接库
将手机号加密为base64格式的密文:
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(#{mobile})))
解密:
utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('密文')))
plsql工具配置多用户:
用户名/密码@ip:端口号/连接库