Need SQL to get Email Addresses for all Managers in Supervisor Hierarchy
Summary
SQL to get Email Addresses for all Managers in Supervisor HierarchyContent
Hi Experts
I am looking for a query which can get me a list of all supervisor's email addresses for a person's supervisor hierarchy.
Here is an example of what i am looking for
Person John has 5 supervisors - the result i am looking for is
sup1@gmail.com, sup2@gmail.com, sup3@gmail.com,sup4@gmail.com, sup5@gmail.com
We are on 19c.
Please let me know if you have any questions on the same. thanks!
Mansur
Tagged:
1