oracle分组合并字段

分组合并前：

select  s.loanid, s.impawtype, s.guartype
  from LOAN_LOANFORMASSURE s
 where s.LOANID = 4449

分组合并后：

select loanid,
       (listagg(impawtype, ',') within group(ORDER BY loanid)) impawtypes,
       (listagg(guartype, ',') within group(ORDER BY loanid)) guartypes
  from LOAN_LOANFORMASSURE 
 group by loanid
having loanid = 4449