Shulou(Shulou.com)06/01 Report--

Mysql > select MD5 (15201061106) +-- + | MD5 (15201061106) | +-+ | ba726d7afbda0488aee313ed5cf31270 | +-+ 1 row in set (0.00 sec)

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;Oracle > select MD5 (15201061106) from dual; MD5 (15201061106)-BA726D7AFBDA0488AEE313ED5CF31270

This string is actually the result of a 16-byte value represented in hexadecimal, where the characters are 0-9 and Amurf, which is why the letters in it are case-independent and represent the same value.

Create or replace function cif_base_kk.MD5 (

Pass in varchar2)

Return varchar2 is

Retval varchar2 (32)

Begin

If pass is null then

Return null

End if

Retval: = utl_raw.cast_to_raw (dbms_obfuscation_toolkit.MD5 (input_string = > pass))

Return retval

End

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.