Oracle 本身不带MD5加密,可自定义函数实现
CREATE OR REPLACE FUNCTION MD5(password IN VARCHAR2)
-- password : 加密的字符串
-- retval : 返回值
RETURN VARCHAR2 IS retval varchar2(32);
BEGIN
retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => passwd));
RETURN retval;
END;
select MD5('myMD5') from dual;
4E590974A12E7F9E9F073EF1EB5C4573