Hello everyone.
I am studying a Oracle SQL on udemy, the instructor created a child table that has foreign key constraint. In the foreign key constraint, he did not specify the primary key column of the parent table. He only referenced the parent table, not the column.
So my question is, is referencing the primary key column of the parent table in the foreign key constraint optional? which seems to be so, if that is the case, does Oracle just use primary key column of the parent table as the referenced column in the foreign key constraint automatically?