Hash Key? 1

[wellster34]

Hi,

Does anybody know anything about Hash Keys on tables? I need to figure out when I join to a table that contains one, to capture the hash key value. Oracle refers to a hash function to get that information but I have not found it yet.

 

[wellster34]

Found it, there is a DBMS_UTILITY.GET_HASH_VALUE where you pass it a VARCHAR2 for the string to convert. The next parameter is a number to indicate the start of the hash key. Final parameter is the size of the hash key.

In order to use it for testing purposes, SELECT DBMS_UTLITY..... FROM DUAL; You can just refer to it as a function since that is what the utility is.

 

[KenCunningham]

Thanks for posting back. Always nice to see an answer to those 'hanging' questions!