Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question and suggestion regarding rownum

Re: Question and suggestion regarding rownum

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Thu, 13 Nov 2003 13:17:09 -0500
Message-ID: <qpqdnbQofZY2Vy6i4p2dnA@comcast.com>


oops, that should have been 'comp.databases.oracle.server'

"mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote in message news:...
> see my reply in the parallel thread on comp.databases.oracle.misc for
> caveats and performance comparisons
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
> news:Q_Nsb.141800$ao4.451892_at_attbi_s51...
> > go to asktom.oracle.com and search. Answer is there.
> > Jim
> > <ketansweta_at_sbcglobal.net> wrote in message
> > news:THFsb.30024$FD7.22223_at_newssvr27.news.prodigy.com...
> > > Hi! Folks
> > >
> > > I am sure many of you have come across this problem which I am facing
> and
> > > hope to have some suggestions.
> > > We have an web application with tones of where clauses and group by
but
> > > eventually the result set could be any where
> > > from 1 to 10000. Now the web page would display only 1 to 10 items
after
> > > which if you would click on next it would show
> > > from 11 to 20 - till here it is some what do able - the problem lies
> when
> > > the user click on directly 45th page which should show records
> > > from 2000 onwards. I was thinking of using the rownum function ..
> remember
> > > this is a select from a 500K table - .
> > >
> > > Any folks who have a better idea or suggestion would be great ful.
> > >
> > > Thanks
> > > Ketan
> > >
> > >
> >
> >
>
>
Received on Thu Nov 13 2003 - 12:17:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US