How to call Oracle MD5 hash function?

by

In Oracle 12c you can use the function STANDARD_HASH. It does not require any additional privileges.

select standard_hash('foo', 'MD5') from dual;

The dbms_obfuscation_toolkit is deprecated (see Note here). You can use DBMS_CRYPTO directly:

select rawtohex(
    DBMS_CRYPTO.Hash (
        UTL_I18N.STRING_TO_RAW ('foo', 'AL32UTF8'),
        2)
    ) from dual;

Output:

ACBD18DB4CC2F85CEDEF654FCCC4A4D8

Add a lower function call if needed. More on DBMS_CRYPTO.

More Related Contents:

  1. REGEX to select nth value from a list, allowing for nulls
  2. PLS-00428: an INTO clause is expected in this SELECT statement
  3. Sleep function in ORACLE
  4. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  5. Subtracting Dates in Oracle – Number or Interval Datatype?
  6. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  7. Receive an unexpected symbol error in my PLSQL query [closed]
  8. PL SQL UPDATE STATEMENT
  9. Search All Fields In All Tables For A Specific Value (Oracle)
  10. Is it possible to output a SELECT statement from a PL/SQL block?
  11. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  12. How to use BOOLEAN type in SELECT statement
  13. create table with sequence.nextval in oracle [duplicate]
  14. IF EXISTS condition not working with PLSQL
  15. How to get the last row of an Oracle table
  16. Is there any way to flush output from PL/SQL in Oracle?
  17. INSERT SELECT statement in Oracle 11G
  18. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  19. PLSQL Insert into with subquery and returning clause
  20. Oracle (Old?) Joins – A tool/script for conversion?
  21. Display names of all constraints for a table in Oracle SQL
  22. Oracle 11g – Check constraint with RegEx
  23. Advice Using Pivot Table in Oracle
  24. How to use a dynamic parameter in a IN clause of a JPA named query?
  25. Creating or simulating two dimensional arrays in PL/SQL
  26. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  27. The network adapter could not establish the connection – Oracle 11g
  28. How to check if a column exists before adding it to an existing table in PL/SQL?
  29. Curious issue with Oracle UNION and ORDER BY
  30. Insert into from CTE

Leave a Comment