oracle 行列转换

with t as
 (select '打包' t， to_char(q.provider_code || '共' || count(1) || '个包裹') n
    from rnrsbrand.query_auction q
   where q.status in (2, 3)
   group by q.provider_code
  union
  select '捆包' t， to_char(pk.provider_code || '共' || count(1) || '个捆包') n
    from rnrsbrand.query_availablepackage pk
   where pk.on_line = 10
     and pk.bid_status = 1
   group by pk.provider_code )
select t,       count(1) || '家供应商投放打包竞价：' || listagg(n, ',') within GROUP(order by n desc)
  from t  group by t