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
>

Look at the DBMS_CRYPTO.HASH function.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm#sthref1559

If that does not meet your needs, then you might have to write your own.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com