Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited
"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