The BULK COLLECT clause can be used with the SELECT INTO statement as follows. (Refer to SELECT INTO for additional information on the SELECT INTO statement.)
If a single collection is specified, then collection may be a collection of a single field, or it may be a collection of a record type. If more than one collection is specified, then each collection must consist of a single field. select_expressions must match in number, order, and type-compatibility all fields in the target collections.
The following example shows the use of the BULK COLLECT clause where the target collections are associative arrays consisting of a single field.
The following example produces the same result, but uses an associative array on a record type defined with the %ROWTYPE attribute.