Oracle存储过程利用游标拼接字符串

Question

想要得到查询结果 类似0Z0001C     0000102508/0000400485/0000102549/0000102510/0000400488

        

create or replace procedure SelectTest(msg out VARCHAR2) as
  v_name varchar2(50);
  cursor c_sell is
    select c.contract_number
      from (select c.roll_plan_number,c.contract_number
              from ecc_oc.sap_contract c, ecc_oc.sales_order_stand t
             where t.roll_plan_number = c.roll_plan_number
             order by c.roll_plan_number);
begin
  open c_sell;
  loop
    fetch c_sell
      into v_name;
    exit when c_sell%notfound;
    msg := msg || v_name || ',';
  end loop;
  close c_sell;
end;

我自己写的     不能实现，大神帮帮忙啊！！！

Answer 1

可是我不会写啊，能详细说一下吗？谢谢啦！！

Answer 2

这是什么呢？

Answer 3

不需要用游标吧，在函数里面查询出来，拼接不就可以了吗？

Answer 4

这是什么？

Answer 5

oracle貌似也有类似于mysql里面的group_concat函数  你可以搜一下

直接用语句group by一下就可以了不用sp

Answer 6

完美解决了我的问题，谢谢啦~~

Answer 7

11g的写法：

SELECT roll_plan_number, 
       listagg(contract_number,'/') WITHIN GROUP(ORDER BY contract_number) 
FROM TABLE GROUP BY roll_plan_number;

10g的写法：

SELECT roll_plan_number, 
       REPLACE(wm_concat(contract_number),',','/') 
FROM TABLE GROUP BY roll_plan_number;