嵌套子查询里面有树形查询

昨天在看落落的博客，http://blog.csdn.net/robinson1988/article/details/7047961

对于子查询反嵌套以及树形查询的关系实在是有点麻烦，稍作个实验。

SQL> select * from emp a where exists (
select ename from emp b where a.empno=b.empno start with ename = 'KING' connect by prior mgr = empno);
Execution Plan
----------------------------------------------------------
Plan hash value: 1890947587

---------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |      |     1 |    45 |    24   (0)| 00:00:01 |
|*  1 |  FILTER                                    |      |       |       |            |          |
|   2 |   TABLE ACCESS FULL                        | EMP  |    14 |   630 |     3   (0)| 00:00:01 |
|*  3 |   FILTER                                   |      |       |       |            |          |
|*  4 |    CONNECT BY NO FILTERING WITH SW (UNIQUE)|      |       |       |            |          |
|   5 |     TABLE ACCESS FULL                      | EMP  |    14 |   196 |     3   (0)| 00:00:01 |
------------------------------------------------------------------------