看看LISTAGG
http://www.oracle-base.com/articles/misc/StringAggregationTechniques.PHP
就像是:
SELECT NAME, LISTAGG(CAR, ',') WITHIN GROUP (ORDER BY CAR) AS CARS
FROM (SELECT NAME,CAR
FROM TABLE1, TABLE2
where TABLE1.IdN=TABLE2.IdC)
GROUP BY NAME;
在ORACLE中,是否有一种方法可以使用两个表将多行行连接为一条,而最终值之间用逗号分隔?
看看LISTAGG
http://www.oracle-base.com/articles/misc/StringAggregationTechniques.PHP
就像是:
SELECT NAME, LISTAGG(CAR, ',') WITHIN GROUP (ORDER BY CAR) AS CARS
FROM (SELECT NAME,CAR
FROM TABLE1, TABLE2
where TABLE1.IdN=TABLE2.IdC)
GROUP BY NAME;