Re: table row "checksum"

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Mon, 9 Jan 2006 09:59:14 +1100
Message-ID: <MPG.1e2c444f5a992f07989742@news.readfreenews.net>

damorgan_at_psoug.org says...
> Geoff Muldoon wrote:
> >
> > Seeking advice as to the best method of generating a "table row checksum".
>
> If 10g look at the ORA_HASH function and the DBMS_SQLHASH built-in
> package.

Thanks Daniel,

ORA_HASH look highly promising, but a read of the doco gives no clear indication on the possibility/probability (when using the default max_bucket setting) of two different strings returning the same number. Any further clues?

GM Received on Sun Jan 08 2006 - 16:59:14 CST