Oracle Database Discussions

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!

UNIQUE INDEX and PRIMARY KEYS

846231Jul 19 2011 — edited Jul 27 2011

Hi Friends,

I am confused about primary keys.
What is the purpose of this key again? I know it is used for unique constraints.
Supposing I have a table with two (2) columns which are each indexed as unique.

Then they can me both candidate at primary key right?

So why do I need a primary key again? when I have 2 columns which are uniquely index?

Thanks a lot

This post has been answered by 878302 on Jul 27 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2011

Added on Jul 19 2011

#general-database-discussions

8 comments

975 views