只问耕耘
分类: Oracle
2010-02-10 09:12:26
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