connect by/start with

使用scott/tiger测试：

1.select empno,job,ename,mgr from emp;

 

2.select empno,job,ename,mgr from emp start with empno=7902 connect by prior empno=mgr order siblings by sal desc;

结果：从empno=7902开始的记录，并且7902的递归所有子记录。

3.select empno,job,ename,mgr from emp start with mgr=7902 connect by prior empno=mgr order siblings by sal desc;

结果：从mgr=7902开始的记录，并且7902的递归所有子记录。

 

4.select empno,job,ename,mgr from emp start with mgr=7902 connect by prior mgr=empno order siblings by sal desc;

结果：从mgr=7902开始的记录，并且7902的递归父节点。

 

5.select empno,job,ename,mgr from emp start with empno=7902 connect by prior mgr=empno order siblings by sal desc;

结果：从empno=7902开始的记录，并且7902的递归父节点。