ed zappulla wrote:
>
> 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
> > >
> > >
> > >
> > >
> >
> >
Why not use a sequence as the PK, and devise a table structure that will
support localised differences?
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Mon Oct 22 2001 - 11:53:29 CDT
