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


Please Help Members By Posting Answers For Below Questions

How does one use sql*loader to load images, sound clips and documents? : aql loader

933


What is t sql used for?

776


What does closing a cursor do?

1026


What is loop in pl sql?

802


How do you identify a primary key?

854


what is cursor. write example of it. What are the attributes of cursor.

1029


What is trigger in sql and its types?

805


What is compound trigger?

778


Is a table valued function object?

808


i have some prob lem to tell me about my self in interview first round ...

1924


Can a commit statement be executed as part of a trigger?

839


How can we avoid duplicating records in a query?

786


what are the differences between binary and varbinary? : Sql dba

757


How is a PL/SQL code compiled?

919


What is the difference between an inner and outer join?

785