September 3, 2015

Difference between collection and bulk binding in SQL

Following at the Differences between collection and bulk binding in SQL

To retrieve multiple rows we can use cursors or bulk collections.
Cursors row by row mechanism so performance decreased.
But collections not row by row process all rows retrieved at time so performance increased.

And bulk bind means doing DML(data manipulation language) operations as a bulk.

By using for all statement we can do bulk-binding.

If you want to do bulk-bind first should use bulk collections .