用法：
LISTAGG(‘待转的列’,’分割符号’) WITHIN GROUP(ORDER BY 列字段) AS XXX 字段 FROM 表 WHERE 条件 group by 分组条件 ;

WITH TEMP AS
 (SELECT 'CHINA' NATION, 'GUANGZHOU' CITY
    FROM DUAL
  UNION ALL
  SELECT 'CHINA' NATION, 'SHANGHAI' CITY
    FROM DUAL
  UNION ALL
  SELECT 'CHINA' NATION, 'BEIJING' CITY
    FROM DUAL
  UNION ALL
  SELECT 'USA' NATION, 'NEW YORK' CITY
    FROM DUAL
  UNION ALL
  SELECT 'USA' NATION, 'BOSTOM' CITY
    FROM DUAL
  UNION ALL
  SELECT 'JAPAN' NATION, 'TOKYO' CITY
    FROM DUAL)
SELECT NATION, LISTAGG(CITY, ',') WITHIN GROUP(ORDER BY CITY) AS CITIES
  FROM TEMP
 GROUP BY NATION
声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。