Oracle Database - Cascade

Card Puncher Data Processing


Update a record in the primary key

how can I update a record in the primary key field which behaves as a foreign key to other tables without altering (disabling) the primary/foreign constraint?

If you create the foreign keys “deferrable”, you can

set constraints deferred;
update parent_table;
update child_table(s);

and the constraint will be verified at the commit instead of at the statement level, allowing you to “cascade” the update yourself.

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Oracle Database Lock Foreign Key Unindexed
Oracle Database - Locks and Foreign Keys - Concurrency control of parent keys

Oracle Database maximizes the concurrency control of parent keys in relation to dependent foreign keys. Locking behaviour depends on whether foreign key columns are indexed. If foreign keys are not indexed,...

Share this page:
Follow us:
Task Runner