I am trying to understand as to how a BEFORE statement-level trigger can be used. Since it is a trigger, one needs to know which rows are being affected.
On 2/18/19 4:06 AM, Jitendra Loyal wrote: > The behaviour is not clear for BEFORE Statement-level Trigger. This is > because transition tables cannot be used. So how does one get access to > the rows being affected? It is not documented either.
If you need the row values then use a FOR ROW trigger.