Re: null as part of key?

From: ed zappulla <zappullae_at_rcn.com>
Date: Mon, 22 Oct 2001 11:40:57 -0400
Message-ID: <9r1eih$aiq$1@bob.news.rcn.net>

I see. What about this case

country
state
city
some other cols

pk = country, state, city

Some contries don't have states; therefore it would be null for those countries.

does this make sense?

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3bd42f49$0$237$ed9e5944_at_reading.news.pipex.net...
> No. Nor in any version. If you think carefully you will see that allowing
> this would be a nonsense.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "ed zappulla" <zappullae_at_rcn.com> wrote in message
> news:9r19h8$jhr$1_at_bob.news.rcn.net...
> > Can a column be null and part of a primary key? oracle 8.1.6
> >
> >
> >
> >
>
>
Received on Mon Oct 22 2001 - 10:40:57 CDT