Trigger Email based on refresh of MV
jamphanAug 11 2011 — edited Aug 12 2011What I am trying to do is when a materialized view is refreshed Oracle will essentially query the MV and for all the branches on the report send an email to the designated person in that branch. Is this possible and what I need help on is how to set the trigger and then the email part. The branch will have to be looked up on a table to get the email address. Thanks for any help on this!