Oracle Oracle's LISTAGG analysis function

Oracle Analytic function--listagg Chapter

(1) Use Listagg to merge multiple rows of data into one line

Example table:

Select  from Order  by Deptno, ename

Suppose there is a requirement that the employee names of the same department in the EMP table be stored on a single line, with different names separated by commas "," and the results are as follows:

We can use the analytic function Listagg inside the oracle11g to implement the SQL statement as follows:

Select         Deptno,       listagg (ename,','Group (order by  as Total_ename  from EMP Group  by Deptno;

Oracle Oracle's LISTAGG analysis function