Thanks Adrian
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.
Regards,
Jiten
On Mon 18 Feb, 2019, 9:42 PM Adrian Klaver, <adrian.klaver@xxxxxxxxxxx> wrote:
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.
>
> Thanks
> Jiten
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
