Answer inline:

> -----Original Message-----
> From: Claudio Valderrama C. [mailto:cvalde@...]
> Sent: Wednesday, June 06, 2001 6:07 AM
>
> > -----Original Message-----
> > From: ft@... [mailto:ft@...]
> > 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?
>
> C.

The difference is that you can make the database return only the data you
need, saving:
- CPU time;
- Memory;
- Bandwith.


Have fun,
Paulo Gaspar