The best replacement for bulk collect is merge.

The best alternatives to bulk collect are rated as following:
★★★★★  merge
★★★★  ref cursor
★★★  insert into
★★  insert into select
★★  cursor
★  insert select

Your alternative for bulk collect is not listed? Suggest!
Speaking about bulk collect, one probably shouldn't forget about limit clause.

Other search terms related to bulk collect and their ratings are:
★★★★★ limit clause
★★★★ ref cursor
★★ ref cursor in oracle
★ limit clause in oracle
★ forall
★ dynamic sql
execute immediate in oracle
You have in mind a companion for bulk collect and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of bulk collect in all years. Click on graph for more.
bulk collect
merge
ref cursor