Search code examples
encryptionplsqloracle12c

decode sh256 in oracle

I want to decode the below hash value to text.

bb37497f9b8cdcccf20ff6eee342bc1f76f72f35a7305af28a81b75d3967ea2f.

I tried below function but gives me the output in special characters

select UTL_I18N.RAW_TO_CHAR('bb37497f9b8cdcccf20ff6eee342bc1f76f72f35a7305af28a81b75d3967ea2f', 'AL32UTF8') from dual;

output

�7I����v�0Z򊁷]9g

any other function would give me the text value?

Solution

  • Hash functions are deliberately one way. So you cannot get the original value from the hash value. (You could use brute force and hash all possible original values and see which yields the given hash value. But that's likely not finishing in your lifetime and will produce false positives because of collisions. So you'd even need some second criteria.) Not in Oracle, not anywhere else...