Foreign Key of composite key in Oracle are not detected
Brought to you by:
johncurrier
In the Oracle 12g database, the foreign key relationships established through two or more fields (compound key) are not detected.
It is verified that in PostgreSQL 8.4.13 this type of relations are detected and managed normally.
Note: in both data engines the foreign key relationship is made using a unique key and not a primary key.