Oracle HASH
Jump to navigation
Jump to search
- ORA_HASH
SQL> select ora_hash('abc') from dual;
ORA_HASH('ABC')
---------------
1194017796
- dbms_crypto.hash
In PL/SQL
dbms_crypto.hash('abc', DBMS_CRYPTO.hash_sh1)
Or in SQL
SQL> select dbms_crypto.hash('abc', 3) from dual
2 ;
DBMS_CRYPTO.HASH('ABC',3)
--------------------------------------------------------------------------------
C714CC5367F7592793BBA0B9024C34CDE763E153
The argument is based on
HASH_MD4 CONSTANT PLS_INTEGER := 1; HASH_MD5 CONSTANT PLS_INTEGER := 2; HASH_SH1 CONSTANT PLS_INTEGER := 3;