Analysis of Oracle recursive query

Recently, we found that in many cases, you need to query the upper-level organizations or lower-level organizations based on the Organization Code. In this post, we use the instance provided by oracle for testing. The example table is scott. emp: The sample data is: query each employee and its subordinates: SELECT lpad ('', LEVEL * 2) | empno | ': '| ename FROM emp start with mgr is null connect by prior empno = mgr; www.2cto.com: Query someone's boss: SELECT lpad ('', (LEVEL) | empno, level from emp start with empno = 7369 connect by prior mgr = empno


Author swingo