Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

updating primary key with the same value

768551Apr 22 2010 — edited Apr 22 2010
We 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2010
Added on Apr 22 2010
1 comment
786 views