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?
Good quality help here...
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.