regexp_substr截取子字符串 和 listagg() WITHIN GROUP () 将多行合并成一行

regexp_substr((listagg(B.CONTRACTTYPE, ‘,’) WITHIN
GROUP(ORDER BY B.CONTRACTTYPE)),
‘[^,]+’,
1,
1) CONTRACTTYPE,

将deptno值相同的数据的ename值拼接成一行显示：

select 
listagg(B.CONTRACTTYPE, ',') WITHIN
                       GROUP(ORDER BY B.CONTRACTTYPE)
from 表名