数据准备
select id,name from JLZQYY.ZZZZZZ_TTZ where id='AA';
查询
SELECT
a.ID,
listagg (a.NAME, ',') WITHIN GROUP (ORDER BY NAME) names
FROM
ZZZZZZ_TTZ a
WHERE
a.id='AA'
GROUP BY
a.ID
数据准备
select id,name from JLZQYY.ZZZZZZ_TTZ where id like'AA%';
查询
SELECT
a.ID,
listagg (a.NAME, ',') WITHIN GROUP (ORDER BY NAME) names
FROM
ZZZZZZ_TTZ a
WHERE
a.id like'AA%'
GROUP BY
a.ID