Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer Posted / swapna

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

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the command line end user interface - mysql? : Sql dba

695


What are different types of statements supported by sql?

817


What is trigger in flip flop?

729


What are the disadvantages of not performing database normalization?

806


What is index example?

749






What is inner join in sql?

771


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

700


Why is the cursor important?

729


What is sql prepared statement?

735


What is procedure in pl sql?

721


How long will it take to learn pl sql?

689


What is the difference between delete and truncate commands?

689


Explain unique key in sql.

738


What is trigger in pl sql?

736


What is trigger with example?

739