Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: null as part of key?
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
![]() |
![]() |