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
bella13
Messages: 90
Registered: July 2005
Member
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: 64140
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.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_util.htm#i1003646

Regards
Michel
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: Fri Dec 09 04:15:08 CST 2016

Total time taken to generate the page: 0.29878 seconds