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