Thanks for all your efforts. I appreciate it. Let us wait and see if someone can enlighten us, or you locate the conversation.
Thanks once again Regards, Jiten On Tue 19 Feb, 2019, 3:19 AM Adrian Klaver, <adrian.kla...@aklaver.com> wrote: > On 2/18/19 9:07 AM, Jitendra Loyal wrote: > > I do understand that the statement level trigger will be executed once > > before the operation. My point is.. if one does not know the rows, what > > kind of use it can be put to. What is the use case? Like in after > > triggers, one gets the rows in transition tables, how does one do with > > vefore trigger. > > Use FOR EACH ROW. > > Why you cannot use a FOR EACH STATEMENT trigger is something I thought I > remember being discussed on the list before. Unfortunately I cannot find > that conversation at the moment. Someone else will need to weigh in on > this. > > > > > Thanks and regards, > > Jiten > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >