Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_sqlhash and online md5 calculator return different results

745509Jun 26 2012 — edited Jun 26 2012
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;
This post has been answered by Prabodh on Jun 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2012
Added on Jun 26 2012
1 comment
526 views