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
Write an sql query to select all records from the table?
What is flag in sql?
Is a view faster than a stored procedure?
What does (*) mean in sql?
What is trigger types of trigger?
Why partition by is used in sql?
Is sql a backend?
What is scalar data type in pl sql?
how do you control the max size of a heap table? : Sql dba
What makes a good primary key?
How to connect a sql*plus session to an oracle server?
How can the performance of a trigger be improved?
Does pl sql work in mysql?
Can dml statements be used in pl/sql?
Is a secondary key the same as a foreign key?