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!

forall or insert into..select from table(collection) ?

user10316500Jun 27 2014 — edited Dec 12 2017

In my procedure

1) I fetch more or less 400 000 records with a bulk collect (limit 20 000)

2) forall insert for each 20 000 records

My question is : I get more performance with FORALL INSERT or using INSERT INTO TABLE ..SELECT * FROM TABLE(collection_name) ?

NB: collection is a table of an object type

Stefano

This post has been answered by Billy Verreynne on Jun 27 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2014

Added on Jun 27 2014

#insert, #select, #table

9 comments

2,464 views