Re: Retrive a set of tuple

Thomas J. Kyte <tkyte_at_us.oracle.com> wrote:
>> I looking for a method to retrive a set of tuples from a table. For
 example
>> I want to retrive from the 15th to 30th tuple without the need to
 keep in
>> memory all tuples e select them from my cgi.
 

> select *
>   from ( select rownum r, a.*
>            from (YOUR_QUERY_GOES_HERE) a
>           where rownum <= :MAX_ROW )
>  where r >= :MIN_ROW
> /

Before your mail, I found NUMROW, so now I do SELECT * from my_table where NUMROW>start_row AND NUMROW<end_row;

Why should I use your query? Where is the difference?

Thank you.

-- 
SysAdm on cantina.students.cs.unibo.it
Undergraduate student of Computer Science 
http://caristudenti.cs.unibo.it/~celli
Key fingerprint = D8BD F3D0 00A5 9C96 4A07  DE62 2A4C EDE1 06AA E5BC