Explain the usage of WHERE CURRENT OF clause in cursors ?
- 3 Answers
- 9874 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 are date and time data types? : Sql dba
What are analytic functions in sql?
Is pl sql still used?
What is the maximum number of triggers, you can apply on a single table?
What is the sql query to display the current date?
What are field types?
Whate is use of MOD function in pl/sql.
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Define commit?
When the mutating error will comes? and how it will be resolved?
What are different types of joins ?
write a qurey for finding the length of the sting.
-
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)
