Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why create a PRIMRY KEY on a VIEW?

user12240205Dec 28 2016 — edited Dec 28 2016

I just found something new today.  I accidently found a view in the USER_CONSTRAINTS DD view which has a PRIMARY KEY.

Then after reading about views I found out that you can in-fact create primary keys for views.

But none of the documentation says WHY we should do that?? What is the advantage or use of creating a PRIMARY KEY on a view?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2017
Added on Dec 28 2016
6 comments
1,001 views