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.