Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / vipul varshney
It allows to apply updates and deletes to the row currently
being addressed, without the need to explicitly reference
the ROWID.
You must include the FOR UPDATE clause in the cursor query
so that the rows are locked on OPEN.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Does sqlite need a server?
What is bulk compiling in pl/sql.?
What is the syntax and use of the coalesce function?
Is vs as in pl sql?
How long it takes to learn pl sql?
what is innodb? : Sql dba
What is constant in pl sql?
What are the different types of a subquery?
What is cursor status?
What is the most important ddl statements in sql are?
Advantages and disadvantages of stored procedure?
What is use of trigger?
Enlist the advantages of sql.
what is auto increment? : Sql dba
Which command is used to delete a package?