Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select ranges of rows
Thanks Thomas and Pablo for your answers.
Pablo: Yes, i want to partition the results of the query in pages, and i've
readed some solutions, althought most of all were complicated or had
problems in some cases. Is there an efficient (and possibly easy) way to
show the results in pages?. I've readed something about a kind of
'bookmarks' in Oracle... do they exist?
thanks again
"Pablo Sanchez" <pablo_at_dev.null> escribió en el mensaje
news:POhe8.98$k54.127533_at_news.uswest.net...
>
> "Kalamaro" <diegoman_at_usuarios.retecal.es> wrote in message
> news:a5bs3b$67a5g$1_at_ID-115330.news.dfncis.de...
> > Hi. I have a problem selecting a range of rows. What i want is to
> get the
> > rows from X to Y in a specific order. I've found that:
> >
> > SELECT *
> > FROM tableX
> > WHERE rowid in (
> > SELECT rowid FROM tableX
> > WHERE rownum <= 7
> > MINUS
> > SELECT rowid FROM tableX
> > WHERE rownum < 5);
> >
> > It works, but it's hard to apply it to my query. Is there another
> way to do
> > the same (with views or something else)?
>
> Is your end-goal to provide the front-end the ability to page through
> the dataset? If so, there are less taxing methods to do this.
> --
> Pablo Sanchez, High-Performance Database Engineering
> www.hpdbe.com
> Available for short-term and long-term contracts
>
>
Received on Mon Feb 25 2002 - 02:21:39 CST