Oracle中的wm_concat函数（实际工作中的应用）

Oracle中的wm_concat函数可以实现字段的合并。

 select replace(TO_CHAR(wm_concat(substr(unitcode, 0, 4))), ',', ''', ''') as UNITCODE
    from (select a.unitcode,
                 CASE
                   WHEN rownum > 0 and rownum <= 10 THEN
                    'A'
                   WHEN rownum > 10 and rownum <= 20 THEN
                    'B'
                   WHEN rownum > 20 and rownum <= 30 THEN
                    'C'
                   ELSE
                    'D'
                 END FlAGIND
            from app_copy a
           WHERE a.orgLevel = '2')
   group by FlAGIND;