Oracle update foreign keys

Or 2 Delete the child row, update the parent row, then re-insert the child with the new foreign key value. Justin Harvey Justin Harvey 14k 2 2 gold badges 25 25 silver badges 30 30 bronze badges. Two thoughts on this If however you must make this change, there are two ways I know of to do it. Joe Joe 2 2 silver badges 9 9 bronze badges. I believe the definition of "primary key" states that it is unique, not that it does not change.

Ideally it won't need to change, but it does happen in real life where things are messy. Ruli 2, 11 11 gold badges 25 25 silver badges 34 34 bronze badges. Alejandra Flores Alejandra Flores 1. Sign up or log in Sign up using Google. Sign up using Facebook. That means the Foreign Key constraint in Oracle is used for binding two tables with each other and then verifying the existence of one table data in other tables.

The foreign key constraints are basically used to enforce referential integrity. This table is going to be the parent table or master table which contains the reference key column.

Here, we created the reference column Id using the Primary Key constraint. Once you created the Department table, now insert some master data into this table by executing the below SQL Script. This table is going to be our foreign key table or child table. Note: The DepartmentId column of the Employee table and the Id column of the Department table must have the same data type otherwise foreign key relationship is not possible. In our case, both columns have the same INT data type.

When you execute the above insert statements, three records are inserted into the Employee table as expected as shown in the below image. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

Viewed 8k times. Is it possible to update all referencing foreign keys in Oracle when updating primary key? Improve this question. Tom V Add a comment. Active Oldest Votes. Improve this answer. Balazs Papp Balazs Papp