Explain the usage of WHERE CURRENT OF clause in cursors ?
Answers were Sorted based on User's Feedback
Answer / madhuri
WHERE CURRENT OF clause is used to update the current row of
the active set of a cursor
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / swapna
WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
What is the mutating table and constraining table?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to take user input in pl sql?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
What is the primary key?
What does := mean in pl sql?
What is the main reason behind using an index?
Is t sql a programming language?
What is difference between sql and mysql?
Can we use two order by clause in query?
what is the difference between granting and creating a view?
What is union, minus and interact commands?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)