Skip to Main Content

SQL & PL/SQL

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 condition in BEFORE INSERT OR UPDATE trigger

jflackAug 4 2021

If I have a BEFORE INSERT OR UPDATE ON my_table FOR EACH ROW trigger.
And I do an UPDATE command that does not actually change anything, i.e. all the :NEW columns = the :OLD columns.
Will the UPDATING condition in the trigger be true?

This post has been answered by Frank Kulash on Aug 4 2021
Jump to Answer
Comments
Post Details
Added on Aug 4 2021
4 comments
9,680 views