One has to pay attention when using holdable cursors, however. Thus, once a transaction has been ended and committed, a subsequent transaction (running in a different application) could inherit existing holdable cursors.
To work with cursors you must use the following SQL statements This section introduces the ways the SQL:2003 standard defines how to use cursors in applications in embedded SQL.
Not all application bindings for relational database systems adhere to that standard, and some (such as CLI or JDBC) use a different interface.
Additionally, a cursor may be INSENSITIVE, in which case the DBMS tries to apply sensitivity as much as possible.
Cursors are usually closed automatically at the end of a transaction, i.e.
In computer science, a database cursor is a control structure 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.The SQL:2003 standard defines positioned update and positioned delete SQL statements for that purpose.Such statements do not use a regular WHERE clause with predicates. The cursor must be opened and already positioned on a row by means of The cursor must operate on an updatable result set in order to successfully execute a positioned update or delete statement.A cursor can be viewed as a pointer to one row in a set of rows.The cursor can only reference one row at a time, but can move to other rows of the result set as needed.A holdable cursor is kept open over COMMIT and closed upon ROLLBACK.