Oracle MD5函数

1.创建

SQL> 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 lower(retval);
END;  2    3    4    5    6    7    8    9   10  
 11  /

函数已创建。

SQL> 

2.使用

SQL> select MD5('CAIWENGUANG') from dual;

MD5('CAIWENGUANG')
--------------------------------------------------------------------------------
2d32a7f9d15eb6693ec3fd33bc7bc6a5

SQL> select MD5('caiwenguang') from dual;

MD5('CAIWENGUANG')
--------------------------------------------------------------------------------
79a7737200b2e56de83c8dfcce23a439

SQL> select MD5('caiGUANG') from dual;

MD5('CAIGUANG')
--------------------------------------------------------------------------------
4e18e8b38e7325ffb704ca6c53a7a577

#######################

迷途小运维随笔

作者：john

本文函数创建脚本来自网络