自建函数:
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;
调用示例:
select md5('55') from dual;