Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which function is to be preferred for hash?

BEDEApr 20 2018 — edited Apr 20 2018

I've seen there are several possibilities of obtaining a hash value:

- ora_hash

- dbms_utility_get_hash_value

- owa_opt_lock.checksum

Which one of the functions is to be preferred? What advantages and what disadvantages presents each of them?

I believe there must be some reasons for such variety, but can't figure out when when it's best to use one or another.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2018
Added on Apr 20 2018
7 comments
3,410 views