Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of index in hive?

727


Can we insert in view in sql?

776


What port does sql server use?

709


how to shutdown mysql server? : Sql dba

743


What is a system versioned table?

702






Does view contain data?

788


What is range partitioning?

692


When should I use nosql database?

726


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2295


What are types of indexes in sql?

747


what are tables and fields? : Sql dba

766


How do you explain an index?

986


Can we perform dml in function?

796


What is delimiter sql?

702


How to select all records from the table?

804