Search notes:

Oracle DBMS_UTILITY.GET_HASH_VALUE

dbms_utility.get_hash_value computes a hash value for a given string (varchar2).

The second parameter (base) specifies the minimum number that is returned.

The third parameter (hash_size) specifies the number of buckets for the hash.

The returned number is an integer between base and hash_size - 1.

select
   dbms_utility.get_hash_value('a',    0, 128) val_1,
   dbms_utility.get_hash_value('a', 1000, 128) val_2
from
   dual;

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206666, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/utility/get/hash_value(55): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle DBMS_UTILITY.GET_HASH_VALUE

See also