In computer science, a database cursor is a mechanism that enables traversal over the records in a database. Cursors facilitate subsequent processing in conjunction with the traversal, such as retrieval, addition and removal of database records.

What is a cursor in database?

A database cursor is an identifier associated with a group of rows. It is, in a sense, a pointer to the current row in a buffer. ... Statements that return more than one row of data from the database server: A SELECT statement requires a select cursor. An EXECUTE FUNCTION statement requires a function cursor.

What is database cursor in SQL Server?

A SQL cursor is a database object that retrieves data from result sets one row at a time. The cursor in SQL can be used when the data needs to be updated row by row. A SQL cursor is a database object that is used to retrieve data from a result set one row at a time. ... This article explains everything about SQL cursors.