Reputation: 568
I am using Oracale SQL Developer, and I am wondering when I insert data into a table, will the data cascade to another table that has the first tables primary key as a foreign key for example if I run
insert into DEPARTMENT values ('1', 'Karate');
Will the first value in Column 'DEPARTMENTID' also be inserted into the other table I.E 'TEACHER' or do I have to manually insert the value into the both tables.
Thanks
Upvotes: 0
Views: 69
Reputation: 37129
No, inserts will not cascade. You'll have to insert data in parent table and then in child tables.
Upvotes: 2