Oracle: Spalten als Zeile (multiple rows as one column) LISTAGG

Direkt aus den Beispielen von Oracle 
 
SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees
FROM   emp
GROUP BY deptno; 
 
ab 11g R2 .. damit für mich jetzt nutzbar. 

http://www.oracle-base.com/articles/misc/string-aggregation-techniques.php

Kommentare

Beliebte Posts aus diesem Blog

using the birt runtime with spring boot and gradle to generate PDF from a Report Design File

Powershell snippet to send messages to telegram