What does SELECT into return?

Question

This tutorial shows you how to use the PL/SQL SELECT INTO statement to fetch data . If the SELECT statement does not return any row, Oracle will raise the .

What is SELECT return?

The SQL SELECT statement returns a result set of records, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data manipulation language (DML) command.

What is SELECT into statement?

The SELECT INTO statement copies data from one table into a new table.

How does SELECT into work?

The SELECT INTO statement is a query that allows you to create a new table and populate it with the result set of a SELECT statement . To add data to an existing table, see the INSERT INTO statement instead. SELECT INTO can be used when you are combining data from several tables or views into a new table.

What is SELECT into in Oracle?

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.

Expert · Answer