oracle my2_ep解密

SELECT CUSCODE,
       UTL_RAW.cast_to_nvarchar2(UTL_RAW.bit_xor(UTL_ENCODE.base64_decode(UTL_RAW.cast_to_raw(SUBSTR(CAST(客户密码 AS VARCHAR2(50)),6))),
                                                UTL_RAW.cast_to_raw('#&^*')))
  FROM TAB_CUSTOMER WHERE length(客户密码) > 1 AND ROWNUM < 20

posted @ 2019-06-12 10:23  空能净  阅读(168)  评论(0编辑  收藏  举报