antonpug antonpug - 6 months ago 25
SQL Question

How to write a FOR EACH loop in PL/SQL?

Is it possible to run a for each loop on a PL/SQL array?

Answer
for i in my_array.first ..my_array.last loop
  --do_something with my_array(i);
end loop;