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 to convert dates to character strings? : Sql dba

777


What is a mutating table and a constraining table?

784


Is sql considered coding?

791


how to decrement dates by 1 in mysql? : Sql dba

776


what are wild cards used in database for pattern matching ? : Sql dba

787


Explain the structure of pl/sql in brief.

819


what is a database? : Sql dba

829


what tools available for managing mysql server? : Sql dba

769


how to shut down the server with 'mysqladmin'? : Sql dba

759


How do you clear the screen in sql?

801


How does sql profiler work?

773


what does myisamchk do? : Sql dba

769


What are joins in sql?

741


Explain the components of sql?

802


Does asenumerable execute the query?

789