What is ON DELETE CASCADE?
Gaurav Malviya
When ON DELETE CASCADE is specified Oracle maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.