尽量使用LISTAGG代替WM_CONCAT

SELECT * FROM TEST_IGNORE;

SELECT T.RCLASS,
       WMSYS.WM_CONCAT(T.BANK) AS BANK
FROM TEST_IGNORE T
GROUP BY T.RCLASS;

SELECT T.RCLASS,
       WMSYS.WM_CONCAT(distinct T.BANK) AS BANK
FROM TEST_IGNORE T
GROUP BY T.RCLASS;

SELECT t.rclass,
       LISTAGG( t.bank,',') WITHIN GROUP(order by t.id) as BANK
FROM TEST_IGNORE t
GROUP BY T.RCLASS;

SELECT T.RCLASS,
       LISTAGG(T.BANK, ',') WITHIN GROUP(ORDER BY T.ID) AS BANK
FROM (SELECT T.RCLASS,
             T.BANK,
             T.ID
      FROM (SELECT T.RCLASS,
                   T.BANK,
                   T.ID,
                   ROW_NUMBER() OVER(PARTITION BY T.RCLASS, T.BANK ORDER BY T.ID) AS RN
            FROM TEST_IGNORE T) T
      WHERE RN = 1) T
GROUP BY RCLASS;