However, you can store columns in your table that refer to values in another table, and use those columns in your composite primary key. So your table may contain columns COLA, COLB and COLC. COLB could be specified so as to enforce a Foreign Key constraint to another table.
You can create a composite primary key on COLA and COLB, while COLB is also participating in the relationship.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.