Re: fetch updated columns in 'before update' trigger
> if I don't have access to a function inside the trigger that tells me what column is being updated,
> then I need a clause inside the trigger for every single column.
Again, SQL is literal in exactly that way. If you want such functionality, you'll need to write a set of set/get update-registration sql functions.
The more usual solution is to maintain an integrated DDL repository that includes all code, not least Triggers, that depends on the DDL.
Subject
Views
Written By
Posted
1311
September 05, 2019 08:27PM
714
September 05, 2019 08:53PM
705
September 05, 2019 09:03PM
675
September 05, 2019 09:57PM
1434
September 05, 2019 10:15PM
Re: fetch updated columns in 'before update' trigger
822
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.