Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: null as part of key?
Just about every country has some political division that functions as a
state does in the US = they're just not called "states".
"ed zappulla" <zappullae_at_rcn.com> wrote in message
news:9r1eih$aiq$1_at_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 - 19:24:45 CDT
![]() |
![]() |