SQL:
SELECT DBMS_OBFUSCATION_TOOLKIT.md5(input => UTL_I18N.STRING_TO_RAW ('pass123'||'46728595335', 'AL32UTF8')) Alias from dual;
Alias
C0FD11DBF7C9FF16AD9CE40E303135B3
Function:
CREATE OR REPLACE FUNCTION Hash_MD5 (p_msisdn IN VARCHAR2) RETURN VARCHAR2 IS
v_secret VARCHAR2(32) := ' pass123';
BEGIN
RETURN (DBMS_CRYPTO.HASH (UTL_I18N.STRING_TO_RAW (v_secret||p_msisdn, 'AL32UTF8'), DBMS_CRYPTO.HASH_MD5));
END Hash_MD5;
select Hash_MD5('46728595335') from dual;
Alias
C0FD11DBF7C9FF16AD9CE40E303135B3