Sequence the trigger execution order
We have an after update trigger for a table. We want to add another trigger for the same table after update event. We prefer this way in order to keep the original trigger intact without any changes.
Our requirement is to ensure the trigger that existed already should execute first when an update happens. Then the new trigger should run. Is their any way to control the sequence of execution for the triggers within a table. How can this be achieved?
Any help on this is very much appreciated.
Thanks