Parameter and Keyword Description:
select_item:
This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the INTO clause.
BULK COLLECT:
The SQL engine is instructed to bulk-bind the output collections before returning them to the PL/SQL engine. The SQL engine bulk-binds all the collections referenced in the INTO list. The equivalent columns should store the scalar (not the composite) values.
variable_name:
This identifies a formerly declared scalar variable into which a select_item value is fetched. For each and every select_item value returned by the query, there should be a equivalent, type compatible variable in the list.
record_name:
This identifies a user-defined or %ROWTYPE record into which the rows of values are fetched. For each select_item the value returned by the query, there should be a equivalent, type-compatible field in the record.
collection_name:
This identifies a declared collection into which the select_item values are bulk fetched. For each of the select_item, there should be a equivalent, type-compatible collection in the list.
host_array_name:
This identifies an array (stated in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable) into which the select_item values are bulk fetched. For each of the select_item, there should be an equivalent, type-compatible array in the list. The Host arrays should be prefixed with a colon.
table_reference:
This identifies the table or view that should be accessible when you execute the SELECT statement, and for which you should have SELECT rights.
Subquery:
This is a SELECT statement which provides a set of rows for the processing.
TABLE (subquery2):
The operand of the TABLE is a SELECT statement which returns a single column value, that must be a nested table or a varray cast as a nested table. The Operator TABLE informs the Oracle that the value is a collection, but not a scalar value.
alias:
This is the other (typically short) name for the referenced, table, column or the view.
rest_of_statement:
This is something which can legally follow the FROM clause in the SELECT statement apart from the SAMPLE clause.