MD5加密函数
create or replace function md5(in_src in varchar2) return varchar2 is
retval varchar2(128);
begin
retval := convert(in_src,'ZHS16GBK');
retval := convert(retval,'UTF8');
retval := Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(INPUT_STRING => retval));
RETURN upper(retval);
end md5;
调用md5函数示例:
select md5('ardo') from dual