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: Paul <paul_at_test.com>
Date: Tue, 21 Jun 2005 17:59:04 +0100
Message-ID: <42b8475d$0$3144$ed2619ec@ptn-nntp-reader01.plus.net>


Jon Heggland wrote:
>>Moreover, as Joe Celko often points out, any key that is used in the UI
>>should have check digits or similar to catch data entry errors
>
> 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.

Paul. Received on Tue Jun 21 2005 - 11:59:04 CDT

Original text of this message

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