Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / 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 |
Post New Answer View All Answers
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is t sql used for?
What does closing a cursor do?
What is loop in pl sql?
How do you identify a primary key?
what is cursor. write example of it. What are the attributes of cursor.
What is trigger in sql and its types?
What is compound trigger?
Is a table valued function object?
i have some prob lem to tell me about my self in interview first round ...
Can a commit statement be executed as part of a trigger?
How can we avoid duplicating records in a query?
what are the differences between binary and varbinary? : Sql dba
How is a PL/SQL code compiled?
What is the difference between an inner and outer join?