oracle pivot 多个字段

select ot.*
  from (select 
               
   
               t2.reject_reason,
               t.user_name,
               t.user_agentid,
               t2.puch_type,
               t2.puch_address,
               long_to_date_str(t2.create_time) as puch_time

          from T_OWS_RFC_SAFEGUARD t
          left join t_ows_rfc_his t1
            on t.opearate_no = t1.operation_no
          left join t_ows_rfc_puch t2
            on t.id = t2.rfc_safe_guardid)
pivot(max(puch_time), max(puch_address) p
   for puch_type in(1 as puch,
                    2 as puch_1
                    )) ot