As has been demonstrated it is possible but I wouldn't do it except as a
parlor trick. If I can't trust a PK to be unique, I'm not writing a query
against it.

S-

On Wed, 6 Apr 2005, Zelli Brian wrote:

> Ok, a stupid question. We are having a debate whether you can create a
> primary key that is non-unique. Logic aside, is it possible in oracle?
> Can you syntactically do it or can't you?
>
> ciao,
> Brian


--
Stephen Rospo Principal Software Architect
Vallent Corporation (formerly Watchmark-Comnitel)
Stephen.[Email address protected] (425)564-8145

This email may contain confidential information. If you received this in
error, please notify the sender immediately by return email and delete this
message and any attachments. Thank you.



Oracle LazyDBA home page