Explain the usage of WHERE CURRENT OF clause in cursors ?
Answers were Sorted based on User's Feedback
Answer / tulsi
WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / rahul koshti
By using WHERE CURRENT OF clause you can update or delete
records from the table where CURSOR fetched the records. But
for this you MUST have to open cursor with the clause of
'FOR UPDATE [OF COLUMN_NAME]'.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / nishi
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amar_kondla
wherecurrent of clause means which is currently being modify
by the view,where not on dml
Is This Answer Correct ? | 2 Yes | 1 No |
How to add a column ‘salary’ to a table employee_details?
Are dml statements autocommit?
in table there r so many rows write a query which two rows r updated last two day befor?
What is mutating table error?
What are few of the schema objects that are created using PL/SQL?
Is like operator in sql case sensitive?
How does a trigger work?
What is difference between nchar and nvarchar?
Are sql database names case sensitive?
In a package if we have 10 procedures or functions,How to know which will execute first?
How do I find duplicates in sql?
what is a trigger? : Sql dba