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.kla...@aklaver.com> 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.kla...@aklaver.com >
