How to print every element of an ARRAY in PL/SQL?

Question

This is a pretty basic question, but here goes:

I have an array of VARCHAR2 strings in PL/SQL.

How can I print every element in that array?

darreljnz · Accepted Answer · 2009-02-08 09:46:15Z

12

for i in my_array.first..my_array.last loop
  --print me
end loop;

answered Feb 8, 2009 at 9:46

darreljnz

2,3802 gold badges18 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JosephStyons · Accepted Answer · 2017-10-23 14:07:24Z

6

for i in my_array.first..my_array.last loop

  dbms_output.put_line(my_array(i).col1Name||'  ' ||  my_array(i).col2Name|| '  '  ||my_array(i).col3Name);

end loop;

edited Oct 23, 2017 at 14:07

JosephStyons

59.1k64 gold badges169 silver badges240 bronze badges

answered Oct 23, 2017 at 6:38

Hiruni K

1892 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to print every element of an ARRAY in PL/SQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related