https://ittichaicham.com/wiki/index.php?action=history&feed=atom&title=Oracle_HASH
Oracle HASH - Revision history
2026-10-14T23:31:48Z
Revision history for this page on the wiki
MediaWiki 1.34.2
https://ittichaicham.com/wiki/index.php?title=Oracle_HASH&diff=1032&oldid=prev
Ittichai: Created page with "* ORA_HASH <pre> SQL> select ora_hash('abc') from dual; ORA_HASH('ABC') --------------- 1194017796 </pre> * dbms_crypto.hash In PL/SQL : dbms_crypto.hash('abc', DBMS_CRY..."
2013-10-31T22:18:31Z
<p>Created page with "* ORA_HASH <pre> SQL> select ora_hash('abc') from dual; ORA_HASH('ABC') --------------- 1194017796 </pre> * dbms_crypto.hash In PL/SQL : dbms_crypto.hash('abc', DBMS_CRY..."</p>
<p><b>New page</b></p><div>* ORA_HASH<br />
<pre><br />
SQL> select ora_hash('abc') from dual;<br />
<br />
ORA_HASH('ABC')<br />
---------------<br />
1194017796<br />
</pre><br />
<br />
* dbms_crypto.hash <br />
In PL/SQL<br />
: <br />
dbms_crypto.hash('abc', DBMS_CRYPTO.hash_sh1)<br />
:<br />
<br />
Or in SQL<br />
<pre><br />
SQL> select dbms_crypto.hash('abc', 3) from dual<br />
2 ;<br />
<br />
DBMS_CRYPTO.HASH('ABC',3)<br />
--------------------------------------------------------------------------------<br />
C714CC5367F7592793BBA0B9024C34CDE763E153<br />
</pre><br />
<br />
The argument is based on<br />
<pre><br />
HASH_MD4 CONSTANT PLS_INTEGER := 1;<br />
<br />
HASH_MD5 CONSTANT PLS_INTEGER := 2;<br />
<br />
HASH_SH1 CONSTANT PLS_INTEGER := 3;<br />
</pre></div>
Ittichai