Re: hash value - function

ciapecki wrote:
> Hi,
>
> Is there any function (10g) that would return a kind of hash value,
>
> I was thinking of getting one value for the whole table.
>
> My idea was to concatenate all the columns (5 columns there not very
> big around 10chars each) get a numerical hash value.
> Then group by primary_key, and get a sum or avg, or whatever.
>
> If the hash value would be big enough I could use it for comparing if
> two tables are the same of the content or not.
>
> the question is, if there is such a function, I could not find it that
> takes varchar2 and returns a value.
>
> thanks
> chris

A rather large number of them it turns out. Here are a few:

DBMS_SQLHASH: http://www.psoug.org/reference/dbms_sqlhash.html
ORA_HASH:     http://www.psoug.org/reference/ora_hash.html
DBMS_CRYPTO:  http://www.psoug.org/reference/dbms_crypto.html
OWA_OPT_LOCK: http://www.psoug.org/reference/owa_opt_lock.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org