Oracle doesn't have the scrollable cursor support?
Whenever accessing Database I would highly recommend that you maintain a table cache of your own inside the program and traverse through the table within that cache. Better not to use ResultSet and replace it with your own Data Structure . There are two reasons why this technique should be followed. First a ResultSet contains mostly redundant info as well and it occupies space in memory for all the time. Secondly most of the time ResultSet if bounded with Database itself and causing delay for extremely large tables, because of the rule of Thumb that HardDisk seek time is much greater than memory access time. A custom data structure (a structure or class) can be very easy to implement since the table entries obtained from the ResultSet are mostly parsed as Strings. We can use any of java.util.Vector or java.util.ArrayList . The ArrayList class is also available in C# under System.Collection.ArrayList . For instance if you have a table like emp in