ORACLE 字串聚合函式 string varchar2 aggregation function

itpremier發表於2011-11-11
Oracle字串函式Function

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/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章