Types of cursors

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

Using a non-scrollable cursor:

The simplest type of cursor is a non-scrollable cursor. A row-positioned non-scrollable cursor moves forward through its result segment one row at a time.