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:
-----------------------------------
ANALYST FORD,SCOTT
CLERK ADAMS,JAMES,MILLER,SMITH
MANAGER BLAKE,CLARK,JONES
PRESIDENT KING
SALESMAN ALLEN,MARTIN,TURNER,WARD
No comments:
Post a Comment