Oracle Alert question Dynamic email

 

Hello,

I have a requirement to create a periodic alert with Dynamic email distribution, The sql for the alert will produce result, the result will have employee numbers as output, Using the employee number, I will have to fetch the email address from another seeded table and send email at run time.

I did see the menu "Distribution List", however I do not have the name of the person to email until the query finds the result.

Please let me know if we have any other option to achieve this.

Thanks

Meenakshi Nallasivan