What are cursors? Explain different types of cursors?

Answer Posted / siva

cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the three basic rules which are to be followed for the relational model of the database?

761


Explain about xml databases?

822


How to use online Backups?

1976


What is the physical representation for a many-to-many relationship?

807


In which table collections errors are stored.

2149


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1796


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

778


What are the types of database model?

787


explain detail about ftp in datastage?

2004


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

2350


Why does this query return 0?

791


How long can an error message be in raiseerror function?

758


Explain about the hierarchical model of the database?

798


How to replace not in with not exist?

1683


What are the 18 schemas?

823