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 to convert dates to character strings? : Sql dba
What is a mutating table and a constraining table?
Is sql considered coding?
how to decrement dates by 1 in mysql? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
Explain the structure of pl/sql in brief.
what is a database? : Sql dba
what tools available for managing mysql server? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
How do you clear the screen in sql?
How does sql profiler work?
what does myisamchk do? : Sql dba
What are joins in sql?
Explain the components of sql?
Does asenumerable execute the query?