I want a neumaric equivalant of a string at meets the following.
1. neumaric value is consistent for a given string.
2. neumaric equivalant is consistent across given strings. Implies neumeric value will be unique for a string. No two strings would give same neumeric value.
I tried DBMS_UTILITY.ge t_hash_value. But many forums say, Oracle claims to be unique. I want a 100% hit ratio at all times.
1. neumaric value is consistent for a given string.
2. neumaric equivalant is consistent across given strings. Implies neumeric value will be unique for a string. No two strings would give same neumeric value.
I tried DBMS_UTILITY.ge t_hash_value. But many forums say, Oracle claims to be unique. I want a 100% hit ratio at all times.
Comment