HomeНаука и техникаRelated VideosMore From: Kishan Mashru

ON DELETE CLAUSE OF FOREIGN KEY CONSTRAINT IN ORACLE SQL WITH EXAMPLE (CASCADE/SET NULL/NO ACTION)

13 ratings | 1300 views
This is a free video tutorial explaining about the nonmandatory on delete clause in the foreign key constraint in Oracle SQL database, the video explains about how the on delete set null and on delete cascade works, how it can be implemented with easy to understand examples. We have also shown practical demonstration on creating the foreign key constraint, and then deleting the data from the parent table and observing the changes that take place in the child table.
Html code for embedding videos on your blog
Text Comments (12)
Sagar Utwani (9 months ago)
Thanks this helped me
Kishan Mashru (9 months ago)
Welcome!!! Hope you have liked the video and subscribed to our channel!!! :)
Raja Govindaraj (10 months ago)
Good and clear explanation... Thanks lot for sharing the knowledge 😊
Kishan Mashru (10 months ago)
Welcome Raja!!! I hope you have liked the video and subscribed to our channel!!! :)
Kishan Mashru (1 year ago)
Yes, you can, delete record first from the child table and then from the parent.
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta
ipseeta sahu (1 year ago)
Hi Kishan, I have a question regarding this. Can we delete records from child table in case the child table does not have ON DELETE CLAUSE specified? Thanks, Ipseeta

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.