CREATE OR REPLACE PROCEDURE aaaa
is begin
for a in 1..100 loop
for b in 1..100 loop
for c in 1..100 loop
end loop;
end loop;
end loop;
end aaaa;
...全文
6035打赏收藏
oracle游标for循环嵌套for循环怎么优化呀?
简单的说就是我有一个存储过程里面嵌套了3个for循环.导致性能很慢数据跑不出来,请问大神有什么方法优化? CREATE OR REPLACE PROCEDURE aaaa is begin for a in 1..100 loop for b in 1..100 loop for c in 1..100 loop end loop; end loop; end loop; end aaaa;