Oracle Magazine, Jan/Feb 2018
Database Developer and DBA ETL CONNECT BY information is incomplete processing many more rows than need to be processed Code Listing 9 Limiting hierarchical queries in CONNECT BY and START WITH SQL select empno rpad level 3 ename ename mgr 2 from emp 3 connect by prior empno mgr 4 and region NORTH 5 start with mgr is null 6 and region NORTH EMPNO ENAME MGR 7839 KING 7566 JONES 7839 7788 SCOTT 7566 7876 ADAMS 7788 7902 FORD 7566 7369 SMITH 7902 7698 BLAKE 7839 7499 ALLEN 7698 7521 WARD 7698 7654 MARTIN 7698 7844 TURNER 7698 7900 JAMES 7698 ORACLE MAGAZINE JANUARY FEBRUARY 2018 100
You must have JavaScript enabled to view digital editions.