Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Retrive a set of tuple
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 E5BCReceived on Wed Jul 05 2000 - 00:00:00 CDT
![]() |
![]() |