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!

need foreign key constraint based on primary key of 2 different table

spur230Nov 14 2013 — edited Nov 14 2013

I am using Oracle 11.2.0.3.

I have 2 table invl with invl_pk as primary key and org with org_pk as primary key. 

In third table entity_list, I  have entity_pk which can either be indvl_pk or org_pk.   How can I can create such constraint?

Thanks for your time.

This post has been answered by Vite DBA on Nov 14 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2013
Added on Nov 14 2013
7 comments
1,040 views