Re: Compare CLOBs over dblink

From: Rich Jesse <>
Date: Mon, 1 Nov 2010 11:19:55 -0500 (CDT)
Message-ID: <>

> I don't have experience comparing "large" lobs over a db link, but I'd be
> inclined to use your dbms_crypto.hash method. Create a new function that
> just calls dbms_crypto.hash and grant execute on that to your developer.

It should be noted that SHA1 hashes are not guaranteed to be 100% unique, but that they are *extremely* unlikely to collide. A quick Google shows the odds at 1 in 2^80.

Thought that disclaimer should be put in there, just in case... :)


Received on Mon Nov 01 2010 - 11:19:55 CDT

Original text of this message