CODEWITHSUNDEEP
sqloracle-sqldeveloper
seus
seus

Reputation: 568

SQL Inserts sql Developer

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

Answers (1)

zedfoxus
zedfoxus

Reputation: 37129

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

Upvotes: 2

Related Questions