How to Implement ON DELETE SET NULL Constraint in Oracle 10g Database.
Hello Friends,
In this Video we will learn ON DELETE SET NULL keyword.
We will be create two tables called 1) dept(Department) and emp(Employee).
Here, dept table will serve as Parent table and emp table will serve as child table.
We will then add Foreign key Constraint at Child table.
we will then populate the data in Parent table and child table.
Our primary purpose is when i delete a particular record from my parent table (i.e. department table/dept) then referenced record column (dno) (i.e. a reference record value (dno) that is referred in child table should become null).
This is the concept of ON DELETE SET NULL i.e you delete a record from parent table and a concerned record value (dno in our case) from child table will null itself and rest of the columns value become as it is.
Thank you for Watching.
Subscribe my Channel for more videos on Database.
Watch video How to Implement ON DELETE SET NULL Constraint in Oracle 10g Database. online without registration, duration hours minute second in high quality. This video was added by user Hardik Parmar 20 April 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 61 once and liked it 8 people.