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 mariadb a nosql database?

760


How to use sql statements in pl/sql?

798


How exception is different from error?

762


How do you use a while loop in pl sql?

717


Is sqlite thread safe?

787






Is sql database free?

699


How many types of cursors are available in pl/sql?

771


What is synchronized subquery?

819


What are the parts of a sql statement?

763


What is a unique key and primary key and foreign key?

742


What are the operators in sql?

750


Can there be 2 primary keys in a table?

725


What is the primary use of normalization?

699


What is the starting oracle error number?

753


How many triggers can be applied to a table?

779