dbms_utility.get_hash_value
computes a hash value for a given string (varchar2
). base
) specifies the minimum number that is returned. hash_size
) specifies the number of buckets for the hash. 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;