Home » SQL & PL/SQL » SQL & PL/SQL » Determine Hash Size for DBMS_UTILITY.GET_HASH_VALUE
Determine Hash Size for DBMS_UTILITY.GET_HASH_VALUE [message #380232] Fri, 09 January 2009 11:39 Go to next message
Messages: 90
Registered: July 2005
How do i determine the hash size for the DBMS_UTILITY.GET_HASH_VALUE function.

I need the hash value to be between 1 and 999999999; what shd the hash value be?

select DBMS_UTILITY.GET_HASH_VALUE ( 'abcd', 1,999999999 ) "Hash Val" FROM dual;

Is 999999999 correct? thanks for your help and time..

Re: Determine Hash Size for DBMS_UTILITY.GET_HASH_VALUE [message #380242 is a reply to message #380232] Fri, 09 January 2009 12:06 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it should be 999999998 as specified in documentation and explained in the example.

Previous Topic: Unable to Insert CLOB
Next Topic: Trying to create fact table and getting error:unable to extend temp segment [merged]
Goto Forum:

Current Time: Wed Oct 26 20:36:25 CDT 2016

Total time taken to generate the page: 0.09923 seconds