Plsql trigger if updating
Oracle Database executes all triggers of the same type before executing triggers of a different type.If you have multiple triggers of the same type on a single table, then Oracle Database chooses an arbitrary order to execute these triggers.Your package should include a counter variable to detect this situation.sal_diff); END; / keyword if you want the trigger to query or change the same table, because triggers can only do that after the initial changes are applied and the table is back in a consistent state.
For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended). If a triggering statement includes a column list, the trigger is fired only when one of the specified columns is updated.
If a triggering statement omits a column list, the trigger is fired when any column of the associated table is updated.