Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: orace sql query
hpuxrac wrote:
> Does it work either way ( having a primary key define on either a
> unique or non unique index )?
That is what my demo clearly showed. Deferrable primary key and unique constraints use NON-unique indexes. The index can NOT be enforcing uniqueness and it sure can't be enforcing a NOT NULL condition.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Jun 24 2007 - 11:49:42 CDT