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 |
what are the features and advantages of object-oriented programming? : Sql dba
Which is better stored procedure or query?
how to install mysql? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What are the advantages of sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is the need of merge statement?
Which tcp/ip port does sql server run?
What is java sql connection?
using subquery how can i calculate working days in a month?
what is denormalization. : Sql dba