CREATE 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;
/
创建成功后,使用MD5()即可对字符串进行加密
SELECT MD5('HELLO') FROM DUAL;