get_hash_val_9i.sql

Oracle PLSQL for DBAs 源代码

CREATE OR REPLACE FUNCTION get_hash_val (p_in VARCHAR2)
   RETURN VARCHAR2
IS
   l_hash   VARCHAR2 (2000);
BEGIN
   l_hash :=
      RAWTOHEX
         (UTL_RAW.cast_to_raw
                           (DBMS_OBFUSCATION_TOOLKIT.md5 (input_string      => p_in)
                           )
         );
   RETURN l_hash;
END;
/