Oracle:将子查询中的多个结果合并为一个以逗号分隔的值

LISTAGG(column_name, delimiter) WITHIN GROUP (ORDER BY column_name)

ID | NAME  | DEPARTMENT
1  | Alice | HR
2  | Bob   | IT
3  | Carol | HR
4  | Dave  | Finance

SELECT LISTAGG(NAME, ',') WITHIN GROUP (ORDER BY NAME) AS employees_names
FROM employees
WHERE DEPARTMENT = 'HR';

EMPLOYEES_NAMES
--------------------------------------------------------------------------------
Alice,Carol