将多列合成一行的方法

这里使用的是pl/sql来实现

declare
        st1 varchar2(1000);
        st varchar2(1000);
       
begin
      st1:='';
      for temp in
     (select package_name
from TD_B_PACKAGE a,
     wqls2 b
where a.package_id=b.package_id) loop
st1:=temp.package_name||'$'||st1;
end loop;
/*   for temp1 in
   (select discnt_name
from TD_B_DISCNT a,
     wqls3 b
where a.discnt_code=b.discnt_code
) loop
st1:=st1||'$'||temp1.discnt_name;
end loop;*/
dbms_output.put_line(st1);
end;