Re: How to hash a set of columns ?

From: Neil Chandler <neil_spam_chandler_at_blueyonder.co.uk>
Date: 8 May 2003 14:49:50 -0700
Message-ID: <48688f65.0305081349.7ff49d84@posting.google.com>

I would only add that Oracle do not guarantee that the dbms_utility.get_hash_value package will not change in future releases --although I don't believe they have changed it so far...

We use the dbms_obfuscation_toolkit.md5 (from Oracle 8i onwards) as MD5 is a standard hashing algorithm, not only implemented within Oracle but elsewhere too.

regs

Neil.

> > SQL>select dbms_utility.get_hash_value('KU$_CONSTRAINT_COL_LIST_T',100,8000) hashval from dual;
> >
> > HASHVAL
> > ----------
> > 4099
> > .. however, original point being: The values are not guaranteed to be unique. Just be aware of it and take appropriate precautions.
> >
> > Anurag
>
> Jusung & Anurag,
>
> Thank you very much for the replies.
>
> Regards
> S Madhusudhanan
Received on Thu May 08 2003 - 16:49:50 CDT