Do you think – that is possible to have a foreign key enable on a child table with the data which is not available in parent table.
Type: Posts; User: srivastava.sujata; Keyword(s):
Do you think – that is possible to have a foreign key enable on a child table with the data which is not available in parent table.
-- I created one table with one unique constraint
SQL> create table t (a int, constraint u_t unique (a))
Table created.
SQL> insert into t values (1);
1 row created.
n Since, we have unique...