What a SELECT FOR UPDATE cursor represent? - The result of a PREPARE statement is a statement identifier. It is a data structure that represents the prepared statement text.
- To declare a cursor for the statement text, we associate +- a cursor with the statement identifier.
- You can associate a sequential cursor with any prepared SELECT or EXECUTE FUNCTION (or EXECUTE PROCEDURE) statement.
- You cannot associate a scroll cursor with a prepared INSERT statement or with a SELECT statement that was prepared to include a FOR UPDATE clause.
- The SELECT FOR UPDATE clause in the cursor declaration is a convenient way of modifying the rows that have been retrieved by the cursor.