Oracle将多行一列转为一行一列的,分隔形式。

with temp as(
select '123' agent_user_id from dual union all
select '456' agent_user_id from dual
)
select listagg(agent_user_id, ',') within group (order by agent_user_id)
from temp