Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer Posted / tulsi

WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is pl sql and postgresql same?

573


what are the advantages a stored procedure? : Sql dba

551


discuss about myisam key cache. : Sql dba

563


What is forward declaration in pl sql?

590


What is an index in sql with example?

519






what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

554


What is difference between primary and secondary key?

519


What does partition by mean in sql?

515


What is the difference between unique and primary key constraints?

588


Name the operator which is used in the query for pattern matching?

505


What is indexing in sql and its types?

547


Does sql support programming?

557


What is scalar function in sql?

532


what are different types of keys in sql?

608


Can primary key be changed?

529