You can use either scroll or no scroll to specify cursor_scrollability. If the cursor is scrollable, you can scroll through the cursor result set by fetching any, or many rows back and forth; you can also repeatedly scan the result set.

All scrollable cursors are read-only, and cannot be used with for update in a cursor declaration.