oracle function函数合并相同列为一行

create or replace function getinvos(v_instoragesumid char)

 return varchar2 as

 invos varchar(500);

 invo varchar(50);

 

cursor cursor_invos is select d.invno

             from stockinvoiceinstorage b,

                  instoragedetailsum    c,

                  stockinvoice          d,

                  stockinvdetail        e

            where b.invdetailid = e.detailid

              and b.instoragedetailid = c.id

              and d.invid = e.stockinvoice_invid

              and c.instorageid = v_instoragesumid group by d.invno;

begin

  open cursor_invos;

  loop

  fetch cursor_invos

       into invo;

     exit when cursor_invos%notfound;

     invos:=invos||' '||invo;

  end loop;

close cursor_invos;

  return invos;

end;