2021-10-19

                                ORACLE-MD5

定义：
create or replace function F_GET_MD5(input_string VARCHAR2) return VARCHAR2 IS
raw_input RAW(128) := UTL_RAW.CAST_TO_RAW(input_string);
decrypted_raw RAW(2048);
error_in_input_buffer_length EXCEPTION;
BEGIN
sys.dbms_obfuscation_toolkit.md5(input => raw_input, checksum => decrypted_raw);
return lower(rawtohex(decrypted_raw));
END F_GET_MD5;

–应用：
select F_GET_MD5(t.ZJHM) 证件号 from tablename t;