oracle 行转列字符拼接,oracle 行转列，用特殊符号拼接

第一种

函数 wm_content(‘待转列名称‘) 11g 往后，不推荐使用

实例

多表关联时可以使用

(SELECT wm_concat(nvl(B1.OPERA_CODE,‘a‘)) AS OPERA_CODE FROM OPERATION_NAME B1 WHERE T1.OPERA_REQ_NO=B1.OPERA_REQ_NO) AS SURGERY_OPER_CODE

第二种

实例

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

用法：

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

oracle 行转列，用特殊符号拼接

标签：sele   tom   order   nat   分割   lan   group   wm_concat   beijing

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/iullor/p/13326538.html