create or replace function MD5(passwd in varchar2) return varchar2 is retval varchar2(50); begin retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => passwd)) ; return retval; end MD5;
用法:
select MD5(password) from table;
create or replace function MD5(passwd in varchar2) return varchar2 is retval varchar2(50); begin retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => passwd)) ; return retval; end MD5;
用法:
select MD5(password) from table;
转载于:https://www.cnblogs.com/bindot/p/oraclemd5.html