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 |
Will truncate release space?
Do view contain data?
What are Global Temporary tables
What are inbuilt functions in sql?
What are the different types of dbms?
What is right join sql?
What does fetching a cursor do?
What is the starting oracle error number?
what is 'force view'?
What is sql profiling in oracle?
Are stored procedures faster than queries?
how many no of table can be join in a sql query.