ref:
http://hi.baidu.com/javashmily/blog/item/426e80ee644c0f06fcfa3c75.html
summary:
LISTAGG Analystic Function in 11g Release 2
SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees FROM emp GROUP BY deptno;[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/350519/viewspace-1056264/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/350519/viewspace-1056264/