Explain the usage of WHERE CURRENT OF clause in cursors ?
- 3 Answers
- 9804 Views
- I also Faced
- E-Mail Answers
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 sql constant?
what is data integrity? : Sql dba
What is a string data type in sql?
Explain Connect by Prior?
When to use inner join and left join?
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
Where the integrity constrints are stored in Data Dictionary?
What is the most important ddl statements in sql are?
Explain how procedures and functions are called in a PL/SQL block ?
How do you truncate?
How do you get all records from 2 tables. Which join do you use?
Why do we use set serveroutput on?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
