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
How do I kill a query in postgresql?
What are pl/sql cursor exceptions?
What does := mean in pl sql?
What is a sql*loader control file?
Why is normalization important?
Is microsoft sql free?
Why do we use function in pl sql?
What are the popular database management systems in the it industry?
What are sql triggers used for?
Explain what is rdbms?
Is pl sql better than sql?
Is sql a backend?
What is the purpose of a sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is a Mapplet?