What are cursors? Explain different types of cursors?

Answer Posted / preethi

Cursors are work areas used for internal processing in
order toexecute an SQL statement.

Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors

Is This Answer Correct ?    28 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate OIDS

1666


Explain what a database is?

615


Explain about network model?

591


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1679


Explain the rollup operator?

615






What are the main phases of database development?

544


Explain the process of the user request and data generating?

658


How would you design a database for an online site, which would average a million hits a day?

585


What is DB Development software?

1619


What is database design and development?

609


How to use online Backups?

1734


What is dbms explain in brief?

570


Explain the cube operator?

607


Where is dbms used?

625


Explain about the database management systems.

572