MJN All Blog Cheatsheets Elasticsearch GCP JS LinuxBash Misc Notes Other ShortcutKeys / - Search

Home / Other / Oracle / Oracle Pivot Column to String 

SELECT
   dept_num
,  LISTAGG( emp_name, ',' ) WITHIN GROUP (ORDER BY emp_name) AS emps
FROM
   emp
GROUP BY
   dept_num
;

This page was generated by GitHub Pages. Page last modified: 20/11/30 18:32