How to simultaneously update 3 fields in 3 different tables

[newbieDev]

Hello,

I am trying to update 3 fields in 3 different tables - these fields are related so for some reason I can't change one before the other. I tried updating the primary table first, and then the other tables using it as a foreign key but it wouldn't let me. Is there a cascade update thing ORACLE? Does anyone know how to do this?

Any help/suggestion will be greatly appreciated.

Thanks.

 

[Dagon]

Copy the parent record to its new ID, update the child tables to point to the new parent ID and then delete the old parent record.