Tuesday 29 April 2014

Oracle 11g -LISTAGG - Row To Column

From Row to Column  Data Manipulation 

SELECT    job
,         LISTAGG (ename, ',') WITHIN GROUP (ORDER BY ename)
                   AS ename_list
FROM      scott.emp
GROUP BY  job;

Output:

JOB           ENAME_LIST
-----------------------------------
ANALYST     FORD,SCOTT
CLERK       ADAMS,JAMES,MILLER,SMITH
MANAGER     BLAKE,CLARK,JONES
PRESIDENT   KING
SALESMAN    ALLEN,MARTIN,TURNER,WARD

No comments:

Post a Comment