Geek Answers Handbook

Oracle ORA_HASH "random"?

Ora_hash is determined by the fact that saving the input and seed constants will lead to a certain output.

But for any seed (including the default value), the ora_hash output must necessarily have a property that:

"There is no method that can be used to predict that the result of ORA_HASH will be higher with any level of success than purely random guessing?"

+4
source share
1 answer

Probably not, no. ORA_HASH not designed as a particularly reliable hashing algorithm - it is, of course, not something you would use as part of a cryptography library, for example, you would use DBMS_CRYPTO.HASH to select the appropriate algorithm and parameters. ORA_HASH designed to efficiently distribute items in baskets (that is, what happens when you divide a table), and be a relatively easy hash algorithm. It is not intended to protect against attacks.

+7
source

More articles:


All Articles