Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Part of a composite primary key requires nulls

Re: Part of a composite primary key requires nulls

From: TurkBear <johng_at_nospam.mm.com>
Date: Tue, 15 Dec 1998 22:57:42 GMT
Message-ID: <3676e92e.1426471@news2.mm.com>


As far as I know, no primary key can be NULL and, by extension, if you have a compound key, no part of that compound may be NULL....

"Stephanie Y" <stephy_at_choicebuilder.com> wrote:

>When I change ONE of three attributes that make up a primary key in a table
>to NULL, Oracle 8 automatically changes this attribute back to NOT NULL. Is
>there a way to do this? I would greatly appreciate it!
>
>--Stephanie
>
>

To reply please remove the 'nospam' part of the address Received on Tue Dec 15 1998 - 16:57:42 CST

Original text of this message

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