State the difference between implict and explict cursor's?

Answer Posted / nageswara rao orsu

Implicit cursors: used for all DML statements and
single-row queries
Explicit cursors: used for queries of zero, one, or
more rows

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the life of an sql statement?

521


What is rank dense_rank and partition in sql?

535


Is sql workbench free?

528


Is sql a microsoft product?

494


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

522






how to write date and time literals? : Sql dba

528


Why do we use joins?

562


What is the sql query to display the current date?

547


What is having clause in sql?

527


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

666


How many clustered indexes can be created on a table?

583


what is offset-fetch filter in tsql? : Transact sql

530


What is nosql db?

537


What is record data type?

512


Explain the purpose of %type and %rowtype data types with the example?

549