Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Should I use PK or Unique Index in this table ?
xtanto wrote:
> Hi,
> SO what should I use on the table ?
> Can I define it as NULLable and put Unique index on it ?
Yes, but then you must ALSO define a primary key, surrogate or otherwise. Without a primary key, how are you going to tell Oracle which row to update with the Employee No value when you get one? Received on Tue Sep 28 2004 - 06:22:39 CDT