关于工作中遇到的ORACLE机构层级关系的递归查询处理

在工作中遇到的机构数据表有15000个机构，需要列出3级机构以上的机构层级关系，原表数据如图：

需要列出的结果格式为：

现解决问题的sql语句如下：

--根据支行递归查询上级机构
select '3200033' as orgid,
       substr(s2.name_path,
              instr(s2.name_path, ',', 1, 2) + 1,
              length(s2.name_path)) as orgname1,
       substr(s2.name_path,
              instr(s2.name_path, ',', 1, 1) + 1,
              instr(s2.name_path, ',', 1, 2) -
              instr(s2.name_path, ',', 1, 1) - 1) as orgname2,
       substr(s2.name_path, 0, instr(s2.name_path, ',') - 1) as orgname3,
       s2.org_level
  from (select ss.orgid,
               ss.orgname,
               ss.parentid,
               substr(sys_connect_by_path(orgname, ','), 2) name_path,
               ss.org_level
          from t_sys_org ss
         start with ss.orgid = '3200033'
        connect by prior ss.parentid = ss.orgid) s2
 where s2.parentid = '2000000'

但此方法只试用于查询3级机构的情况，而且需要查询多个机构时需要写循环来实现，希望工作中遇到该种类问题的朋友提供经验交流，谢谢！