When a SELECT statement picks the data from any table, the rows are not locked. And while the user performs some operation on the data, there is a chance that some other user may delete or modify the data.
To resolve this, we can use the FOR UPDATE clause, which locks the rows picked up in the select statement and releases the locks only after the code block is exited. Ex-
CURSOR cursor_name
IS
select_statement
FOR UPDATE [OF column_list] [NOWAIT]
This cursors select statement has put a lock on the selected rows and will be released only after the cursor is closed.
The NOWAIT clause is optional and it means that the control will not wait for the resources to be available. the
To resolve this, we can use the FOR UPDATE clause, which locks the rows picked up in the select statement and releases the locks only after the code block is exited. Ex-
CURSOR cursor_name
IS
select_statement
FOR UPDATE [OF column_list] [NOWAIT]
This cursors select statement has put a lock on the selected rows and will be released only after the cursor is closed.
The NOWAIT clause is optional and it means that the control will not wait for the resources to be available. the
