oracle SQL

1:级联查询子树

SELECT code
          FROM students
         where valid_flag = 1
         START WITH id IN
                    (select t.id
                       from students t
                      where t.valid_flag = 1
                        AND t.code IN ('370100', '370200', '370700'))
        CONNECT BY prior id = pid

2：级联查询父树

select * from students start with id=12022766  connect by prior pid = id;

3:多条数据合并成一条

3.1:sqlOutter1.append(" (select business_id, wmsys.wm_concat(examine) examine_project from table1 d, ");

3.2:sqlOutter1.append(" (select business_id,XMLAGG(XMLELEMENT(E,examine||',')).EXTRACT('//text()').getclobval() as examine_project from table1 d, ");

XMLAGG更好一点