Oracle的md5

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('lw112190') from dual

 

posted @ 2022-06-30 15:28  天天代码码天天  阅读(20)  评论(0)    收藏  举报  来源