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

Home -> Community -> Usenet -> c.d.o.server -> Re: null as part of key?

Re: null as part of key?

From: Van Messner <vmessner_at_bestweb.net>
Date: Mon, 22 Oct 2001 20:24:45 -0400
Message-ID: <tt9ee91hs1em62@corp.supernews.com>


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

Original text of this message

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