About cursors

A database Cursor is an object which is used for pinpoint records in a database. Cursor is Just like a typing cursor that is used to alert you where your text will appear. A database Cursor also shows you the specific record in a database that is being worked upon. When a database file is opened the Cursor points to the first record in the file and using various commands the Cursor can move to any location within the file. At designing of database time the developer must take care not to use too many open cursors. Each cursor uses small amount of memory and the cursors are never closed after completing their work that Cursor hold some memory which create a performance problems.