Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Referential Integrity On Delete Set Null

2776946Apr 18 2015 — edited Apr 18 2015

Let's say I have 3 tables.

Tab_1 has a PK on t1_col1

tab_2 has a foreign key on t2_col1 which references t1_col1

tab_3 has a foreign key on t3_col1 which references t2_col1

if I set my foreign key constraint in table 2 with a on delete set null option, this means that deleting primary key values from table 1 sets those columns on t2_col1 to null.

What happens to the values in t3_col1, do they become null as well, or remain the same..?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2015
Added on Apr 18 2015
2 comments
1,098 views