Re: referential intergrity

From: Anne-Marie Ternes <anne-marie.ternes_at_cie.smtp.etat.lu>
Date: 1998/03/09
Message-ID: <3503A685.4131EB77@cie.smtp.etat.lu>#1/1

Tong Zhai wrote:
>
> > Hi, all:
> > we are setting up a db, one of the table is works_on, and the primary key
> > for that table are composite of project_number and Employee_ssn, so by
> > definition they can't be null, but if I do want to insert a record with
> > null project_number, how can I do that ?
> >
> > tong.

Hi,
as Oracle doesn't absolutely require a primary key, try using a UNIQUE key, which allows nulls.

Anne-Marie Ternes

anne-marie.ternes_at_cie.etat.lu Received on Mon Mar 09 1998 - 00:00:00 CST