問題文
A block has to place the salary of one employee into a local variable and the developer is deciding how to write the query. Which description of the role of the INTO clause in a SELECT INTO statement is correct?
選択肢
- It names the variables that receive the columns of a single row, so the query has to return exactly one row for the statement to finish without raising an exception of its own.
- It names the variables that receive the columns of a single row, so the query returns the first row and quietly discards the rest of the rows that match the stated condition.
- It names the table that supplies the rows of the result, so the query can return any number of rows and the engine keeps the last one that it read from that table for the block.
- It names the columns that the query reads from the table, so the list of variables is written after the FROM clause and the engine matches them by position at run time.