Types of cursor locks and explanation each of them ?
Answer Posted / kalyan dhara
FOR UPDATE and CURRENT OF
---------------
When you issue a SELECT...FOR UPDATE statement, the RDBMS
automatically obtains exclusive row-level locks on all the
rows identified by the SELECT statement, holding the records
“for your changes only” as you move through the rows
retrieved by the cursor. No one else will be able to change
any of these records until you perform a ROLLBACK or a COMMIT.
CURSOR toys_cur IS
SELECT name, manufacturer, preference_level,
sell_at_yardsale_flag
FROM my_sons_collection
WHERE hours_used = 0
FOR UPDATE;
UPDATE table_name
SET set_clause
WHERE CURRENT OF toys_cur ;
OR
DELETE FROM table_name
WHERE CURRENT OF toys_cur ;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the current version of sql?
Is sql sequential or random?
How exception is different from error?
Is a table valued function object?
How is pl sql different from sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is primary key and foreign key?
What found sql?
What is a primary key sql?
how can we repair a mysql table? : Sql dba
What is the difference between union and union all command?
what is commit? : Sql dba
Explain some predefined exceptions.
What is the difference between microsoft access and sql server?
what is the difference between union and union all? : Sql dba