I have gone through the documentation quite a number of times to establish the understanding. However, I had been wondering about the recursion in the case I put forth.
Is there a better way to handle this requirement? The point is that the trigger is being called when no rows are affected.
Thanks and regards,
Jiten