Learn Oracle SQL : Hierarchical Pseudo-Columns

Learn Oracle SQL : Hierarchical Pseudo-Columns: In this video, I explain the use of some pseudo-columns that are available in hierarchical queries in Oracle.

[MotoExploring]

SELECT empno, ename, job, PRIOR ename as manager, level, CONNECT_BY_ISLEAF
FROM emp
WHERE level > 2
OR CONNECT_BY_ISLEAF = 1
START WITH mgr is null
CONNECT BY mgr = PRIOR empno
ORDER BY level DESC;