What a SELECT FOR UPDATE cursor represent?

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.
What WHERE CURRENT OF clause does in a cursor?
PL/SQL provides the WHERE CURRENT OF clause for both UPDATE and DELETE statements inside a cursor.....
Can you pass a parameter to a cursor?
PL/SQL also allows you to pass parameters into cursors. It eases your work because.....
Functioning of CURSOR FOR LOOP with example
A Cursor is a PL/SQL construct and accesses the stored information in a named work area.....
Post your comment