看看LISTAGG
http://www.oracle-
base.com/articles/misc/StringAggregationTechniques.php
就像是：
SELECt NAME, LISTAGG(CAR, ',') WITHIN GROUP (ORDER BY CAR) AS CARSFROM (SELECt NAME,CARFROM TABLE1, TABLE2where TABLE1.IdN=TABLE2.IdC)GROUP BY NAME;
看看LISTAGG
http://www.oracle-
base.com/articles/misc/StringAggregationTechniques.php
就像是：
SELECt NAME, LISTAGG(CAR, ',') WITHIN GROUP (ORDER BY CAR) AS CARSFROM (SELECt NAME,CARFROM TABLE1, TABLE2where TABLE1.IdN=TABLE2.IdC)GROUP BY NAME;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
