In MS SQL Server it is possible to create a foreign key with *ON UPDATE CASCADE* option, so whenever you update one of the columns in the primary key, the foreign keys in other tables will also be update by the DBMS.

So, how to do it in Oracle?