SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Employee and manager levels

User_VKU4XFeb 22 2019 — edited Feb 22 2019

I want to find each employee and up to 3 managers up in the entire organization like below. We have position management implemented.

Employee, Manager1 -> Manager 2 -> Manager -> 3

SELECT REPORTS_TO, EMPLID

FROM PS_POS_DATA_EF_VW A, PS_POSN_INCUMENT B

WHERE EFF_STATUS='A'

CONNECT BY NOCYCLE PRIOR REPORTS_TO=A.POSITION_NBR

Thanks!

This post has been answered by Frank Kulash on Feb 22 2019

Jump to Answer

Added on Feb 22 2019

2 comments

490 views