ORACEL 树形 层级 查询

 查询出符合条件的行。以及下面所有层级

<span style="font-size:18px;">select   hrm_b_eva_Item.* from hrm_b_eva_Item  start with  id in 
( select c.id  from hrm_b_eva_tpl_i a inner join 
(select * from hrm_b_eva_tpl where id=:ID)
 b  on a.base_id=b.id inner join hrm_b_eva_Item c on a.item_id=c.id) 
connect by prior id = parent_id</span>