antonpug antonpug - 5 months ago 12
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;