updating primary key with the same value
768551Apr 22 2010 — edited Apr 22 2010We have some sql sentences that are automatically generated by the development ide.
The update sentences sets alll columns including the primary key, like that:
UPDATE TABLE_A
SET C1 = :NEW_C1,
C2 = :NEW_C2,
C3 = :NEW_C3
WHERE C1 = :OLD_C1
As the application does not allow the user to change the primary key, the value for NEW_C1 is the same value (so, NEW_C1 = OLD_C1) and the primary key will not be changed.
My question is: even if the primary key is set with the same value, does oracle performs any constraint checking on tables that uses the column as a foreing key?
Thaks in advance,
Lenin.