这里使用的是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;