ORA_HASH
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.
Syntax
ORA_HASH (expr [, max_bucket [, seed_value ] ])
Parameters
- expr
-
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.
- max_bucket
-
The maximum bucket value returned by the function. You can specify any value between 0 and 4294967295. The default is 4294967295.
- seed_value
-
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.
