Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bulk collection Add records

VPrasadApr 28 2016 — edited Apr 29 2016

Hi Team,

I need to append records into collection variable;

for i in 1..10 loop

select i bulk collect into collection_variable from dual;

end loop;

current result would be: storing only 10 record.

But required output : i need to store all records.

This post has been answered by Paulzip on Apr 29 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2016
Added on Apr 28 2016
10 comments
1,326 views