.... for i in 1 .. 1000 loop open l_rc for ‘select object_name from all_objects where object_id = :x’ using i; fetch l_rc into l_dummy; close l_rc; end loop; ............以上循环中,select ... 部分只解析一次, 但是如果把where object_id = :x’换成 where object_id = ’|| i 就要解析1000次. 当然是前者会比后者快.
....
for i in 1 .. 1000
loop
open l_rc for
‘select object_name
from all_objects
where object_id = :x’
using i;
fetch l_rc into l_dummy;
close l_rc;
end loop;
............以上循环中,select ... 部分只解析一次, 但是如果把where object_id = :x’换成
where object_id = ’|| i 就要解析1000次. 当然是前者会比后者快.