Re: hash value - function

> I wanted to use this procedure to check periodically if a table
> changed.
> I would save the original hash value, and run periodically checks on
> the table if the hash value is different,
> if it is the case it means the content of the table changed.

Do you want to guard against changes to the table? If so, put the table in a READ ONLY tablespace.

If you just want to know *if* the table has been changed, then implement auditing on the table. You'll not only know *if*, but *when* and *who* as well.

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