oracle如何创建MD5加密函数?

CREATE OR REPLACE FUNCTION fn_md5 (input_string IN VARCHAR2)
 RETURN VARCHAR2
IS
 raw_input RAW (128) := UTL_RAW.cast_to_raw (input_string);
 decrypted_raw RAW (2048);
 error_in_input_buffer_length
 EXCEPTION;
BEGIN
  DBMS_OBFUSCATION_TOOLKIT.md5 (input => raw_input,checksum => decrypted_raw);
 RETURN LOWER (RAWTOHEX (decrypted_raw));
END;

select fn_md5('123') from dual; (就可以看见对123 的加密 -------------------202cb962ac59075b964b07152d234b70)

版权声明：本文为wxy0123450原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。