使用数据库HR scheme的表作为示例。
1SELECT t.employee_id 2 ,listagg(t.job_id,',') within GROUP (order by t.job_id) 3FROM job_history t 4GROUP BY t.employee_id;
EMPLOYEE_ID LISTAGG(T.JOB_ID,',')WITHINGROUP(ORDERBYT.JOB_ID)
1 101 AC_ACCOUNT,AC_MGR
2 102 IT_PROG
3 114 ST_CLERK
4 122 ST_CLERK
5 176 SA_MAN,SA_REP
6 200 AC_ACCOUNT,AD_ASST
7 201 MK_REP