Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 3 Answers
- 11260 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
Can two tables have same primary key?
What is dml statement?
what are date and time data types in mysql? : Sql dba
How do you create a unique index?
how can you create an empty table from an existing table? : Sql dba
Is sql similar to python?
How global cursor can be declare with dynamic trigger ?
What is a trigger word?
what is the difference between delete and truncate statement in sql? : Sql dba
Is nosql faster than sql?
What is the difference between Union and Union all. Which is faster.
Is grant a ddl statement?
How to run sql*plus commands in sql developer?
Mention what does the hierarchical profiler does?
What is pl sql script?
