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 |
select sal from emp group by sal
Which is better join or subquery?
What is rename in sql?
What is left inner join in sql?
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
What is dense_rank in sql?
Does group by remove duplicates?
What is replication id?
Describe different types of general function used in sql?
What are the datatypes available in pl/sql ?
How do I know if I have sql express or standard?