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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Newbie question

Re: Newbie question

From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Wed, 22 Jun 2005 08:55:45 +0200
Message-ID: <MPG.1d2329e0546f2a8c9896ab@news.ntnu.no>


In article <11bgseiseqng1ce_at_corp.supernews.com>, misha_at_no_mishapen_spam.co.uk says...
> Paul wrote:
> > Jon Heggland wrote:
> >>Why is that? Just to avoid a lookup on the key value?
> > I guess it's a practical consideration so that simple typos can be
> > trapped by the client, to save hitting the database server. In some
> > scenarios this could be useful.
>
> Primarily it is required to prevent simple typos (or misread
> handwriting, or misheard phone calls) from picking up another (but wrong
> ) entity.

I don't see how that is possible. If a key value picks up a wrong entity, then the value must obviously be valid according to the checksum algorithm, so it won't help at all.

-- 
Jon
Received on Wed Jun 22 2005 - 01:55:45 CDT

Original text of this message

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