Re: 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: Tue, 30 Jun 1998 11:53:13 GMT
Message-ID: <Jk4m1.1033$P06.379983_at_pm01nn>
Date: Tue, 30 Jun 1998 11:53:13 GMT
Message-ID: <Jk4m1.1033$P06.379983_at_pm01nn>
Can someone point to some references which explain how one can use a PL/SQL table to achieve this ?
Also, if one has to
"first load the table or file prior to using the data ",
does it mean each time a record is added, the whole table has to be reloaded
??
what does loading a table in PL/SQL imply, how expensive will it be for very large tables?
thanks
rakesh
Received on Tue Jun 30 1998 - 13:53:13 CEST