Oracle Function List

LISTAGG

SELECT job_id, LISTAGG(last_name,',') WITHIN GROUP(ORDER BY last_name) AS employee
FROM employees
GROUP BY job_id
ORDER BY job_id
/

JOB_ID              EMPLOYEES

-----------------------------------------------------------------------------------------------------------------

PU_CLERK

Baida,Colmenares,Himuro,Khoo,Tobias

PU_MAN

Raphaely

SA_MAN

Cambrault,Errazuriz,Partners,Russell,Zlotkey

SA_REP

Abel,Ande,Banda,Bates,Bernstein,Bloom,Cambrault,Doran,Fox,Grant,Greene,Hall,Hutton,Johnson,King,Kumar,Lee,Livingston,Marvins,McEwen,Olsen,Ozer,Sewall,Smith,Smith,Sully,Taylor,Tucker,Tuvault,Vishney

SH_CLERK

Bell,Bull,Cabrio,Chung,Dellinger,Dilly,Everett,Feeney,Fleaur,Gates,Geoni,Grant,Jones,McCain,OConnell,Perkins,Sarchand,Sullivan,Taylor,Walsh

ST_CLERK

Atkinson,Bissot,Davies,Gee,Ladwig,Landry,Mallin,Markle,Marlow,Matos,Mikkilineni,Nayer,Olson,Patel,Philtanker,Rajs,Rogers,Seo,Stiles,Vargas