SQL Inserts sql Developer

Question

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

no, you cannot have one insert add data to two tables. it's not insert into foo,bar values ..., after all. — Marc B
– Marc B, Commented Sep 17, 2015 at 16:25
Thank you for clearing this up! I just thought that it would cascade maybe :S — seus
– seus, Commented Sep 17, 2015 at 16:25
If there were more required (not null) information in the teacher table, how could it get it? Always need to create the parent before the child when foreign keys are involved. — Kritner
– Kritner, Commented Sep 17, 2015 at 16:27

zedfoxus · Accepted Answer · 2015-09-17 16:25:43Z

2

No, inserts will not cascade. You'll have to insert data in parent table and then in child tables.

answered Sep 17, 2015 at 16:25

zedfoxus

37.4k5 gold badges68 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

seus Over a year ago

Thank you so much for clearing this up! I will mark the answer as correct

Collectives™ on Stack Overflow

SQL Inserts sql Developer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related