大家帮帮忙看看我的问题

[beanren2009]

declare
cursor cr is select distinct aihao from f where aihao is not null;
v_aihao varchar2(10);
v_sql varchar2(500);
begin
v_sql := 'select country ';
open cr;
fetch cr into v_aihao;
while cr %found loop
v_sql:=v_sql||' , sum(case aihao when ''' || v_aihao || ''' then renshu else 0 end) as ' || v_aihao;
fetch cr into v_aihao;
end loop;
v_sql:=v_sql || ' from F group by country' ;
execute immediate v_sql;
end;
返回结果:

COUNTRY 斗地主 读书 玩火
-------------------- --------- --------- ---------
美国 0 20 40
南非 30 90 0
中国 23 12 45

用C#怎么来调用我上面写的这个游标来出现我要的返回结果,先谢谢了,请给我看看.

[liujiayu10]

写进存储过程里啊

[jietuan]

你用游标，最好放到存储过程里面，存储过程可以封装比较复杂的业务逻辑！