'Select Into'Statement retrieves rows and columns from one source table to a target table.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The SQL SELECT INTO statement can be used to create backup copies of tables.
- The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
- What is the syntax of select .... into statement
- The result of a SELECT statement can contain duplicate rows.
- How many rows can be retrieved using a SELECT INTO statement in an application?
- Select can be used in FROM clause of SQL select.
- PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows
- Explicit cursors are used to process multiple row SELECT statements