Cursors

A cursor is a mechanism that points to one row in a set of rows from the segment. Your application program can use a cursor to retrieve rows from a segment.

Types of cursors
You can declare row-positioned non-scrollable cursor to retrieve data from the result table.

Parent topic: Retrieving a set of rows by using a cursor