SQL - Foreign Key - On Delete Cascade - On Delete Set Null

In this session we will understand the application of On Delete Cascade and On Delete Set Null clauses while creating Foreign Keys in SQL. Demo using Oracle 11g XE

[@yegireddipratibha1739]

Clearcut explanation thank you sir for ur efforts making this video

[@lukasmendez9434]

Very helpful video! Thank you so much

[@ramyaaddanki9665]

Clear concept.Thank u Sir

[@alulahabesha7207]

very helpful! Thanks

[@SatishCJ]

Glad it was helpful!

[@alexey.zaitsev]

Thanks!

[@kasunkumarasinghe6365]

very useful content. thank you

[@SatishCJ]

Glad it was helpful!. Thanks for the feedback

[@prithvirajpatil312]

If we don't use on delete cascade. Will it delete data from only one table?

[@SatishCJ]

You will not be able to delete the parent table records without deleting the child records. I hope it helps.