![oracle apex sql alter table constraint foreign key oracle apex sql alter table constraint foreign key](https://i.stack.imgur.com/O5mPb.png)
![oracle apex sql alter table constraint foreign key oracle apex sql alter table constraint foreign key](https://i.ytimg.com/vi/p0nvQZqcCyI/maxresdefault.jpg)
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS sub query clause.
![oracle apex sql alter table constraint foreign key oracle apex sql alter table constraint foreign key](https://i.ytimg.com/vi/RTpDhNG3yeE/maxresdefault.jpg)
There are a few things which you should know about the foreign key (Features of Foreign Key): While the constraint which involves more than one column in foreign key in the child table as well as more than one column in reference key in the parent table is called Composite Foreign Key. What Are Simple & Composite Foreign Key Constraints?Ĭonstraint which involves only one column in foreign key in child table and one column in reference key in parent table is called Simple Foreign Key. Similar to primary key constraint Foreign Key constraint is also of two types: