hash value - function

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 Received on Tue Aug 14 2007 - 10:54:24 CDT