The ORA_HASH function computes a hash value for a given expression. This function is useful for operations such as analyzing a subset of data and generating a random sample.
The data for which you want the function to compute a hash value. There are no restrictions on the type or length of data represented by expr.
The maximum bucket value returned by the function. You can specify any value between 0 and 4294967295. The default is 4294967295.
A value between 0 and 4294967295. The default is 0. When you want to produce different has values for the same set of data, specify a value for this argument.