oracle数据库MD5加密函数

2. CREATE OR REPLACE FUNCTION fn_md5 (input_string IN VARCHAR2)
3.     RETURN VARCHAR2
4. IS
5.     raw_input                        RAW (128) 
6.                                            := UTL_RAW.cast_to_raw (input_string);
7.     decrypted_raw                    RAW (2048);
8.     error_in_input_buffer_length     EXCEPTION;
9. BEGIN
10.     DBMS_OBFUSCATION_TOOLKIT.md5 (input => raw_input,
11.                                   checksum => decrypted_raw
12.                                  );
13.     RETURN LOWER (RAWTOHEX (decrypted_raw));
14. END;
15. /

运行即可