Cursor for updating a column plsql


01-Aug-2017 21:41

Table 1: Possible error messages if INTO and SELECT lists do not match A SELECT-INTO is also referred to as an implicit query, because Oracle Database implicitly opens a cursor for the SELECT statement, fetches the row, and then closes the cursor when it finishes doing that (or when an exception is raised).

Visit PL/SQL Challenge to read a complete explanation of the answers to this quiz. If the SELECT statement identifies more than one row to be fetched, Oracle Database will raise the TOO_MANY_ROWS exception.

If the statement doesn’t identify any rows to be fetched, Oracle Database will raise the NO_DATA_FOUND exception.