In MS SQL Server you'll be able to produce a foreign key with ON UPDATE CASCADE option, so if you update among the posts however key, the foreign secrets in other tables may also be update through the DBMS.

So, how to get it done in Oracle?

Would a database trigger get the job done for you personally ?

This is actually the Oracle doc about Data Integrity for 11g (just incase you had been interested).

Oracle doesn't allow an overseas Key constraint with “ON UPDATE CASCADE”.

Here are a handful of options you've.

Produce the Foreign Key, and make an “On Update” trigger. Take advantage from the package below (must be set up in the db).

Tell me for those who have additional questions or require more information.