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

Is oracle and sql same?

565


What are sql commands?

497


Can you do multiple joins in sql?

543


Explain raise_application_error.

640


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

592






What are sql*plus environment variables?

552


What is procedure function?

533


Why partition by is used in sql?

551


What is difference between left and right outer join?

513


Can you call pl/sql package functions from within a fast formula?

560


What are character functions?

625


How can I make sql query run faster?

556


What is write ahead logging in sql server?

555


What is pl sql record in oracle?

563


What is an oracle stored procedure?

586