Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 3 Answers
- 11400 Views
- I also Faced
- E-Mail Answers
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
What is string data type in sql?
What are the advantages of pl sql over sql?
What is composite data type in pl sql?
Why is partition used in sql?
What is parameter substitution in sql?
Explain the difference between rename and alias?
What is difference between left and right outer join?
How many joins can you have in sql?
What does truncate mean in sql?
Enlist the advantages of sql.
What is a relationship and what are they?
What is varchar used for?
What is error ora-01000: maximum open cursors exceeded
What is pl sql collection?
what are date and time functions in mysql? : Sql dba
