Do we care if someone tries to update them at the same time ?
Also, if the result that was to be achieved with a combination of SELECT FOR UPDATE and DELETE CURRENT OF statement could be done in a single delete statement (with a sub-query) can it be error-prone in a multi-user env ?
In the online version (which also matches the quiz offered at PL/SQL Challenge, both a and b are correct.
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.
When you fetch a row the current row position moves to next row.
The SELECT FOR UPDATE statement allows you to lock the records in the cursor result set.
Is it possible to update a column or a row using a cursor?
A cursor can hold more than one row, but can process only one row at a time.
The set of rows the cursor holds is called the set.
The SQL cursor has additional attributes, %BULK_ROWCOUNT and %BULK_EXCEPTIONS, designed for use with the FORALL statement.
A cursor is a temporary work area created in the system memory when a SQL statement is executed.