0

I am using Oracle 11g. It has one schema and the schema has DETAILS table.

DETAILS table has 10 columns.

But my requirement is i want to get a hashcode based on 3 column values by calling Oracle MD5 hash function.

Is it possible?

Thanks!

user755806
  • 6,565
  • 27
  • 106
  • 153
  • possible duplicate of [Is there any hash function in PL/SQL?](http://stackoverflow.com/questions/5595774/is-there-any-hash-function-in-pl-sql) – Jeffrey Kemp Mar 20 '14 at 08:12

1 Answers1

0

If it is not already done you need to: grant execute on dbms_crypto to 

SYS.dbms_crypto.hash(SYS.utl_raw.cast_to_raw( column1 || column2 || column3  ), <hashtype>)
--Where hashtype is integer:
-- 1 = MD4
-- 2 = MD5
-- 3 = SHA1
wittrup
  • 1,535
  • 1
  • 13
  • 23