Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer Posted / madhuri

WHERE CURRENT OF clause is used to update the current row of
the active set of a cursor

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dirty read sql?

469


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1630


What is crud diagram?

504


What is sqlca in powerbuilder?

554


How many sql databases can you have on one server?

584






What is using in sql?

551


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

577


What is the difference between unique and primary key constraints?

582


What is the unique index?

518


What is the difference between a subquery and a join?

520


Is it possible to pass parameters to triggers?

561


Explain the difference between 'between' & 'and' operators in sql

523


How many databases can sql express handle?

524


Can we call a function containing dml statements in a select query?

537


How do I kill a query in postgresql?

541