The following shows the syntax for the BULK COLLECT clause with the SELECT INTO statement. For details on the SELECT INTO statement, see SELECT INTO.
If you specify a single collection, then collection can be a collection of a single field, or it can be a collection of a record type. If you specify more than one collection, then each collection must consist of a single field. select_expressions must match all fields in the target collections in number, order, and type-compatibility.
This example uses the BULK COLLECT clause where the target collections are associative arrays consisting of a single field:
This example produces the same result but uses an associative array on a record type defined with the %ROWTYPE attribute: