Oracle Magazine, Jan/Feb 2018
Database Developer and DBA ETL ORACLE MAGAZINE JANUARY FEBRUARY 2018 92 3 start with mgr is null 4 connect by prior empno mgr SYS_ CONNECT_ BY_ PATH ENAME KING KING JONES KING JONES SCOTT KING JONES SCOTT ADAMS KING JONES FORD KING JONES FORD SMITH KING BLAKE KING BLAKE ALLEN KING BLAKE WARD KING BLAKE MARTIN KING BLAKE TURNER KING BLAKE JAMES KING CLARK KING CLARK MILLER BEYOND THE BASICS For many developers navigating the hierarchy and displaying the depth is where their usage and understanding of hierarchical queries come to an end but there are many more features available One of the reasons for reticence about using hierarchical queries is that in explorations beyond the simple examples using the EMP
You must have JavaScript enabled to view digital editions.