Re: orace sql query



EdStevens wrote:
On Jun 22, 12:15 pm, sathishkes...@xxxxxxxxx wrote:
i want to create table with primary key but with out index

How do you think Oracle enforces the PK?

Not with an index. Indexes have nothing to do with primary key
enforcement. Consider, for example, a deferred constraint which
is built with a non-unique index.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.