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 .
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 .