oracle加密MD5

CREATE OR REPLACE FUNCTION MD5(temp IN VARCHAR2) RETURN VARCHAR2 IS
  retval varchar2(500);
BEGIN
  retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => temp));
  RETURN retval;
END;
/

 

创建MD5加密FUNCTION

使用：

SELECT MD5("123456") FROM DUAL;