Re: SELECT

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 21 Sep 2001 15:27:25 GMT
Message-ID: <x%Iq7.7486$JN.23502@news1.sttls1.wa.home.com>

I think this works
select ... from (select rownum,.... from mytable where non_rownum_predicates) where rownum>x and rownum<y; Look at the AskTom web site. Sure he has it. http://asktom.oracle.com/pls/ask/f?p=4950:1: http://asktom.oracle.com/pls/ask/f?p=4950:8:138613::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:555422909506,%7Brownum%7D and
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:127412348 064
Jim
"Uli Herberg" <ulrich.herberg_at_lrz.tu-muenchen.de> wrote in message news:9ofd69$8gk$1_at_wsc10.lrz-muenchen.de...
> > No, it's not strange, it's that I am a bloody idiot:
> > from the Oracle documentation:
> >
> > Conditions testing for ROWNUM values greater than a positive integer are
> > always false.
> >
> > http://technet.oracle.com/doc/server.815/a67779/ch2.htm#33158
> >
> > So, there is no way to restrict the resultset returned
> > from row...to row...
>
> Isn't there any workaround? I'm writing a java servlet which displays the
> entries to the user. The user should always see 30 entries and then be
able
> to see the switch to the next 30 entries. I don't want to display 10000
> entries in one page!!!
>
> Thanks,
> Uli
>
>
Received on Fri Sep 21 2001 - 10:27:25 CDT