Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can blob be compared?

Re: Can blob be compared?

From: <ctcgag_at_hotmail.com>
Date: 07 Apr 2003 16:11:48 GMT
Message-ID: <20030407121148.628$ff@newsreader.com>


Simon Hall <Simon.Hall_at_logicacmg.com> wrote:

>

> Just a thought - when you create (or change) the blob create a checksum.
> Then when you want to compare blobs, compare the length and the checksum
> instead. Only if both match do you then need to compare the blobs byte
> for byte.

Would it be possible to do this in a single query? I.E, does the where logic of a query apply short-circuiting logic, and if so is the order of evaluation controllable (or even predictable)?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB
Received on Mon Apr 07 2003 - 11:11:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US