Skip to Main Content

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!

Oracle 12c: Primary and Foreign Key on same column at a time

Ahmed HaroonJan 25 2018 — edited Jan 25 2018

hi all,

SQL> select banner from v$version;

BANNER

-----------------------------------------------------------------------------

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

PL/SQL Release 12.1.0.1.0 - Production

CORE    12.1.0.1.0      Production

TNS for Linux: Version 12.1.0.1.0 - Production

NLSRTL Version 12.1.0.1.0 - Production

Can I create a column of a table as Primary and Foreign Key at a time ? if yes, how it can be done ? please help.

regards

This post has been answered by Pierre Yotti on Jan 25 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2018
Added on Jan 25 2018
6 comments
3,510 views