Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Level Count in Hierarchy for Org Chart

Nitin Joshi4 days ago

Hi All,

I'm trying to get hierarchy level count again each employee but unable to get it. Tried many combinations of "CONNECT BY PRIOR" but not getting the desired result.

below is what i'm looking. In org chart, want to count the layers against each employee.

Table below in image has the desired output.

DB Version : 12.2.0.1.0

Thanks in advance!
This post has been answered by Paulzip on Mar 26 2025
Jump to Answer

Comments

Processing

Post Details

Added 4 days ago
#connectby, #hierarchysql
11 comments
113 views