Re: Migrating an Application from SQL Server 2000 to Oracle 10g

From: yossarian <yossarian99_at_operamail.com>
Date: Wed, 23 Jul 2008 17:16:01 +0200
Message-ID: <48874b31$0$29978$5fc30a8@news.tiscali.it>


DA Morgan wrote:

> A key never changes. If it can then, by definition, it is not a natural
> key.

Sometimes the user may want to correct a natural key typo after he has populated child tables too. Obviously, Oracle does not allow to modify the key in this situation ; anyway, the code to write to accomplish this task is trivial.

Y. Received on Wed Jul 23 2008 - 10:16:01 CDT

Original text of this message