OCI/ PL/SQL - Given a table with a large number of rows - how to implement "get next n rows" and "get prev n rows"

From: rakesh <rakesh_at_mci2000.com>
Date: Thu, 25 Jun 1998 07:24:35 GMT
Message-ID: <TWmk1.1425$Ux2.210205_at_pm01nn>

[Quoted] There is a table with a large number of records (>10000) OR a select statement results in number of rows which is so large that the client cannot cache all the rows.

The client wants to get rows in batches (say of 100) from the Database and also be able to scroll through the result set. i.e. from a given row it should be able
to say "get previous n rows" or "get next n rows".

What is the most optimal way to implement this using OCI or PL/SQL. if any.

Thanks
rakesh Received on Thu Jun 25 1998 - 09:24:35 CEST