Geoff Muldoon wrote:
> 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
My recollection is about 1 in 2 billion. But you might want to confirm
that.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jan 09 2006 - 13:39:58 CST
