Oracle SELECT INTO Statement

SELECT INTO Statement
The SELECT INTO statement retrieves data from one or more database tables, and assigns the selected values to variables or collections. For a full description of the SELECT statement, see Oracle Database SQL Reference.

In its default usage (SELECT ... INTO), this statement retrieves one or more columns from a single row. In its bulk usage (SELECT ... BULK COLLECT INTO), this statement retrieves an entire result set at once