1、建一函数
CREATE OR REPLACE FUNCTION t (idt varchar2) RETURN varchar2
IS BEGIN
declare
str1 varchar2(200);
str varchar2(10);
cursor c1 is select test_value from table1 where test_id=idt;
begin
str1:='';
open c1;
loop
fetch c1 into str;
exit when c1%notfound;
str1:=str1||str;
end loop;
close c1;
return str1;
end;
end;
2、运行查询
sql>select test_id,t(test_id) from table1 group by test_id
CREATE OR REPLACE FUNCTION t (idt varchar2) RETURN varchar2
IS BEGIN
declare
str1 varchar2(200);
str varchar2(10);
cursor c1 is select test_value from table1 where test_id=idt;
begin
str1:='';
open c1;
loop
fetch c1 into str;
exit when c1%notfound;
str1:=str1||str;
end loop;
close c1;
return str1;
end;
end;
2、运行查询
sql>select test_id,t(test_id) from table1 group by test_id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货