Skip to Main Content

APEX

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!

insert multiple records based on multiselect listOfValues

hemant_kNov 6 2021

hi
How do I insert records in my table based on a selection from LOV or a select list?
e.g.
3 items are selected and I want to insert three records
begin
for i in 1..selection.count loop
insert into mytable
(a,b,c) values (:a,:b,:c);
end loop;
end;
How do I capture the count here?
I am working on 5.1

This post has been answered by fac586 on Nov 6 2021
Jump to Answer
Comments
Post Details
Added on Nov 6 2021
3 comments
554 views