Thursday 4 January 2007

The DBMS_UTILITY.GET_HASH_VALUE function

I always forget the name and syntax of this function. So I thought I better make a note of it on my blog.

Parameters

There are three IN parameters to the function

Name :- Text string to be used as the basis of the hashing.

Base :- The lowest number you want for the hash value.

Hash_size:- Size of the hash table.

Returns

A numeric value which is derived from the IN parameter ‘name’.

No comments: