获取树叶子节点数据

  
select z.ID,z.parentid,z.ProjectName,z.isleaf from (
SELECT w.ID, w.parentid, w.ProjectName,CONNECT_BY_ISLEAF isleaf
  from (select a.ID, a.parentid, a.ProjectName
          FROM bo_project a, bo_planproject b
         WHERE b.projectid = a.ID
           AND B.ISCANCEL <> 2
        ) w
 start with w.parentid = 0
connect by prior w.id = w.parentid
)z where z.isleaf=1