What is "Fetching rows with a scrollable cursor" all about?
See Question&Answers more detail:osIt creates a cursor for the query, which allows you to iterate over the result set without fetching the whole result at once. A scrollable cursor, specifically, is one that allows iterating backwards.
Example use: You can scroll forward until you find the record you need and iterate back to fetch the previous records, if you need them, too.