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: ed zappulla <zappullae_at_rcn.com>
Date: Tue, 23 Oct 2001 11:35:19 -0400
Message-ID: <9r42jv$joa$1@bob.news.rcn.net>


not true

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:tt9ee91hs1em62_at_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 Tue Oct 23 2001 - 10:35:19 CDT

Original text of this message

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