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

I have a few records all are same structures data, I want to store data in multiple targets how

2140


What is a database development?

522


Write the fastest query to find out how many rows exist in a table?

661


What are the key features of dbms?

565


You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

525






Explain what a database is?

613


Explain about post-relational databases?

581


What is dbms explain in brief?

563


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

547


What is data modeling with example?

530


fact table and dimension table containg one to many relationship or many to one relastionship

2078


How to combine two function together?

1659


What are the three types of database design?

541


How is data stored in dbms?

521


In which database can extended stored procedures be added?

528