The difference is that you can use the ROWNUM in the same
(_declarative_) query as the two examples previously posted showed.
One example was for selecting a subset, the other one used the ROWNUM
in

SELECT .... WHERE ROWNUM IN (subquery or list)


Fred

--- In IBDI@y..., "Claudio Valderrama C." <cvalde@u...> wrote:
> > -----Original Message-----
> > From: ft@c... [mailto:ft@c...]
> > Sent: Martes 5 de Junio de 2001 15:51
> >
> > Yes, please read all the posts in this and a related thread.
ROWNUM
> > is the index within a result set, not in a table. One of its uses
> > with Oracle is for selecting subsets of the result set.
>
> How can the server know the rownum of all the result set in
advance? Does it
> fetch all the result set on a temporal space? If this is the trick,
how is
> this different than having middleware?
>