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: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 29 Aug 2007 16:55:48 +0200
Message-ID: <46d58901$0$231$e4fe514c@news.xs4all.nl>

"Tony Rogerson" <tonyrogerson_at_torver.net> schreef in bericht news:fap82s$jna$1$830fa795_at_news.demon.co.uk...
> The Natural key to a book is it's ISBN number, that has changed over the
> past 10 years.
>

No. If the key changes, it is a new book! Keys can not change! (Want a new car? Get a new licence plate!)

I worked for a school that changed their codes for certain classes, which where used as keys in a (gov) reporting system. Now they are confonted with the fact that over 50% of their students do not graduate.... because no one graduated on the old coded classes. Cost them a lot of money and their good name. So far for changing natural keys!

Shakespeare
(What's in a key?) Received on Wed Aug 29 2007 - 09:55:48 CDT

Original text of this message

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