entre ces deux traitements, lequel et le plus rapide?
/* 1er traitement */
DECLARE
CURSOR C IS
select name
from table;
operation table%ROWTYPE
BEGIN
open c;
loop
fetch c into operation;
exit when c%notfound;
...
end loop;
close c;
END;
/* 2ème traitement */
DECLARE
CURSOR C IS
select name
from table;
BEGIN
for c_temp in C loop
...
end loop;
END;
Partager