Shreenivas

• Sep 22nd, 2005

 

A scrollable cursor, however, can move forward and backward, and can seek any desired record in the cursor.  Such operations are common in applications that present results sets in scrolling windows.  With a scrollable cursor, application developers do not need to create and manage their own buffer for the records.  

YESTHA BAPNA

• Jul 31st, 2007

 

With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor.
the rows of a table can be fetched many times
Sequence is repeated each time FETCH statement is issued