oracle可用如下语句 select A.id ,cursor(select B.id from B where B.id=A.id) from A 请问后回的结果,在程序里也样接受?
create or replace function get_Contents return varchar2 is Result varchar2(100); cursor rad_cursor is select distinct book from tableA; begin Result:=''; for v_sor in rad_cursor loop Result:=Result||v_sor.Contents; end loop; return(Result); end get_Contents; /select get_Contents from dual;
如上表,求sum(id) 将得到 6
上面的功能就上当于sum(contents)="abc"
当然这只是举个列子,好像没有这样的函数,
能不能想一些别的方法呀,
如decode,rownum,cursor之类的组合,
我试了很久,没有做出来,
所以在这请大家帮助了
select A.id ,cursor(select B.id from B where B.id=A.id) from A
请问后回的结果,在程序里也样接受?
return varchar2 is
Result varchar2(100);
cursor rad_cursor is
select distinct book from tableA;
begin
Result:='';
for v_sor in rad_cursor loop
Result:=Result||v_sor.Contents;
end loop;
return(Result);
end get_Contents;
/select get_Contents from dual;