Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 3 Answers
- 11060 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 are the various levels of constraints?
what is the difference between delete and truncate statement in sql? : Sql dba
How does left join work in sql?
What is sorting in sql?
What are pl/sql packages?
what is offset-fetch filter in tsql? : Transact sql
What is sql and also describe types of sql statements?
How to Declare Fixed Length String Value In PL SQL
Differentiate between sga and pga.
What is orm in sql?
What is the difference between cross join and natural join?
What is the difference between cluster and non-cluster index?
Do we need commit after truncate?
how to create a new table by selecting rows from another table in mysql? : Sql dba
what is difference between delete and truncate commands? : Sql dba
