fetch updated columns in 'before update' trigger
Posted by:
Jon Beyer
Date: September 05, 2019 08:27PM
Is it possible to access the updated columns in a 'before update' trigger? I know that I can check columns one by one, but I want an expression that isn't dependent on updating the trigger as I add more columns.
To provide more color, once a record is in a certain state, only one column should be able to be updated. So I want to reject updates unless this one column is the only column that is to be updated.
Many thanks in advance!
Subject
Views
Written By
Posted
fetch updated columns in 'before update' trigger
1071
September 05, 2019 08:27PM
576
September 05, 2019 08:53PM
561
September 05, 2019 09:03PM
541
September 05, 2019 09:57PM
1180
September 05, 2019 10:15PM
647
September 06, 2019 09:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.