Re: Retrive a set of tuple

From: Simone Celli_Marchi <celli_at_cantina.students.cs.unibo.it>
Date: 2000/07/05
Message-ID: <8jutdl$q61$1@le.cs.unibo.it>#1/1

Eugenio <eugenio.spadafora_nospam_at_compaq.com> wrote:
> You should use the Thomas's query because
> ROWNUM is a pseudo-column populated during the query itself.

And if I apply it on a view?
Example:

SELECT * from my_view where ROWNUM>x AND ROWNUM<y ?

> I hope that helps

Yes, 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

Received on Wed Jul 05 2000 - 00:00:00 CDT