Alphanumeric string to number

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hemantshinde
    New Member
    • Sep 2007
    • 3

    Alphanumeric string to number

    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.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    can you kindly specify what exactly ,u want to achieve.

    Comment

    • hemantshinde
      New Member
      • Sep 2007
      • 3

      #3
      Get a numeric value for a string. A string size can be 10 chars to 5000 chars.

      Comment

      Working...