Use case for BEFORE STATEMENT level trigger

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Use case for BEFORE STATEMENT level trigger

Jitendra Loyal
I had been wondering as to where one can use BEFORE STATEMENT level trigger, more so because one does not know (access) what rows are getting affected. Only thing which comes to my mind is that if one wants to do something at a table-level, then this trigger can be used; this is quite unusual though as I have not experienced this need in more than two decades of developing business applications. I am looking forward to some one who can enlighten me with the use case because I may be missing something.

Thanks