Expand description
Cursor execution (SQL:1999 Feature E121)
This module provides execution support for SQL cursor operations:
- DECLARE CURSOR: Declare a cursor for a query
- OPEN cursor: Execute the query and materialize results
- FETCH: Retrieve rows from an open cursor
- CLOSE cursor: Close and release cursor resources
Cursors provide a way to iterate over query results row by row, which is useful for processing large result sets without loading everything into memory.
Structsยง
- Cursor
- A cursor holding query definition and materialized results
- Cursor
Executor - Executor for cursor operations
- Cursor
Result - Materialized cursor result set
- Cursor
Store - Storage for cursors within a session
- Fetch
Result - Result of a FETCH operation