The best replacement for collect is prepaid.

The best alternatives to collect are rated as following:
★★★★★  prepaid
★★★  prepaid freight
★★★  gather
★★★  pick up
★★  map
★★  accumulate
★  amass
★  prepaid shipment
★  prepaid shipping
★  each ruby
★  select ruby
★  collate
★  freight prepaid
★  prepaid and add
★  map scala
★  third party
★  prepaid shipments
  merge
  cursor
  3rd party billing
  fetch
  listagg
  opening prayer
  distribute

Your alternative for collect is not listed? Suggest!
Speaking about collect, one probably shouldn't forget about for loop in oracle.

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



Google Trends

Scale is based on the average worldwide traffic of collect in all years. Click on graph for more.
collect
prepaid
prepaid freight