Does anybody know which way dbms_sqlhash.gethash() works?
I don't get the same result for string 123456.
Online md5 calculator (http://md5-hash-online.waraxe.us/) returns e10adc3949ba59abbe56e057f20f883e.
DBMS_SQLHASH.GETHASH() returns 7E8FEB2276322ECDDD4423B649DFD4D9.
--the second parameter value 2 means MD5 hash.
select DBMS_SQLHASH.GETHASH('select 123456 from dual',2) from dual;