50
of 62
BULK COLLECT (1)
u
BULK COLLECT clause
Ø
The idea:
§
Fetch a group of rows all at once to the collection
§
Control a number of fetched rows (LIMIT)
Ø
Risks:
§
Does not raise NO_DATA_FOUND
§
Could run out of memory
