cursor xiaogaida is select col1 from yourtable;
v_col1 varchar2(8);open xiaogaida;
loop
fetch col1 into v_col1;
exit when xiaogaida%notfound;
...
end loop;
close xiaogaida;
v_col1 varchar2(8);open xiaogaida;
loop
fetch col1 into v_col1;
exit when xiaogaida%notfound;
...
end loop;
close xiaogaida;
set @sqls = 'select ......'
exec sp_executesql @sqls, N'@n_1 decimal output' out
应该怎么写?
execute immediate ' ... ';
sqls varchar2(200);
cursor xiaogaida is select .....;
begin
open ciaogaida;
loop
fetch xiaogaida into n_1;
exit when xiaogaida%notfound;
sqls:'select ....';
--这里执行存储过程,不知道你要实现什么功能
end loop;
end;