oracle的“低于配置单元查询”等价于什么？

select appn_id,collect_set(CONCAT(upper(TRIM(dcsn_type_nm)),':',upper(TRIM(dcsn_outcm_nm))))
 FROM  <left join between few tables>
 group by appn_id

编辑：
根据戈登的回答更新-

select appn_id,listagg(upper(trim(dcsn_type_nm)) || ':' || upper(trim(dcsn_outcm_nm))) within group (order by null) set_type_outcm_nm
 FROM  <left join between few tables>
 group by appn_id