Oracle Database - Cascade

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);
commit;

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

• http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:914629004506
• http://asktom.oracle.com/~tkyte/update_cascade/index.html