| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Newbie question
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.
-- JonReceived on Wed Jun 22 2005 - 01:55:45 CDT
![]() |
![]() |