Re: Extracting a piece of a cursor

Maybe something like

select *
from ( select rownum row, table.*

             from table ) a.
where a.row between 1000 and 1100;

"Francesco M." <fmarchioniNIENTESPAM_at_libero.it> wrote in message news:UK49a.176847$ZE.5303458_at_twister2.libero.it...
> Hi all Oracle Users,
> I need to write a Stored Procedure that extract
> a "piece" of a large resultset. Let's say I want to retrieve
> from record n. 1000 to record n. 1100 of a Table. What's the
> best way (for performance and less impact on the db)
> to do it in PL/SQL ?
> Thanks
> Francesco
>
>
>
Received on Tue Mar 04 2003 - 11:00:37 CST