select contractdetailid ,listagg(valuename,',')within group (order by valuename) as reson
from approvedetail a left join (select * from dictionary where type ='SAPApproveCode' and languagecode= 'cn') b on a.APPROVEREASON = b.value
where contractdetailid =100008079
group by contractdetailid
使用listagg(字段,',') within group(order by xxx)