比如
create or replace function all_note(p_gradeid in number , p_Classid in number)
as
v_all_notes varchar2(1000);
begin
for i in (select note from t_name where gradeid = p_gradeid
and Classid = p_Classid ) loop
v_all_notes := v_all_notes ||'/' ;
end loop;
return v_all_notes ;
end;作者: redj 时间: 2006-09-01 13:12
提示: 作者被禁止或删除 内容自动屏蔽作者: rollingpig 时间: 2006-09-01 15:40
create or replace function all_note(p_gradeid in number , p_Classid in number)
as
v_all_notes varchar2(1000);
begin
for i in (select note from t_name where gradeid = p_gradeid
and Classid = p_Classid ) loop
if(v_all_notes is null ) then
v_all_notes := i.note ;
else
v_all_notes := v_all_notes||'/' ||i.note ;
end if;
end loop;
return v_all_notes ;
end;作者: blue_stone 时间: 2006-09-01 17:08
我写了一个聚合函数, 可以把字符串连接起来 http://bbs.chinaunix.net/viewthr ... &extra=page%3D1作者: redj 时间: 2006-09-01 19:03
提示: 作者被禁止或删除 内容自动屏蔽