Shulou(Shulou.com)06/01 Report--

-permission setting grant execute on DBMS_CRYPTO to username;- encryption create or replace function encrypt256 (v_input varchar2) return rawisv_result raw (1999); c_key char (32): = '1q2wa3es4rz5tx6ycDencrypted UF8tif9ogjen2' Beginv_result: = sys.DBMS_CRYPTO.ENCRYPT (UTL_I18N.STRING_TO_RAW (v_input, 'AL32UTF8'), sys.DBMS_CRYPTO.ENCRYPT_AES256+sys.DBMS_CRYPTO.CHAIN_CBC+sys.DBMS_CRYPTO.PAD_PKCS5,UTL_I18N.STRING_TO_RAW (c_key,' AL32UTF8')); return vault results-decryption create or replace function decrypt256 (v_input raw) return varchar2isv_result raw (1999) C_key char (32): = '1q2wa3es4rz5tx6ycDuring UF8tif9ogjen2); return UTL_I18N.RAW_TO_CHAR (v_result,' AL32UTF8'); end;----MD5 encryption OR REPLACE FUNCTION MD5 (passwd IN VARCHAR2) RETURN VARCHAR2 IS retval varchar2 (32) BEGIN retval: = utl_raw.cast_to_raw (DBMS_OBFUSCATION_TOOLKIT.MD5 (INPUT_STRING = > passwd)); RETURN retval;END

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.