The scrollable cursor moves forward and backward through the result set. With a scrollable cursor, your application can request by position the data presented in the current row. Typical scrolling requests include moving one row forward, one row back, to the beginning, or to the end of the result set.
With a scrollable cursor, your application can request that a certain row of data be made the current row more than once. Cursors without this ability are called forward-only (or non-scrollable) cursors.
The scrollable cursor is not as fast as a forward-only cursor, but if your application needs to browse back and forth in the result set, the scrollable cursor is a good choice.