Trying to do it off the top of my head. But why not look at the URL
postings. Gee they might be of some help.
"TurkBear" <noone_at_nowhere.com> wrote in message
news:i6rmqtgroqpdbmhogg207cqbcjafaq43cv_at_4ax.com...
>
> Nope.. the 'where rownum > x and rownum < y ' clause will fail..
>
>
> "Jim Kennedy" <kennedy-family_at_home.com> wrote:
>
> >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:12741234
8
> >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
> >>
> >>
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Fri Sep 21 2001 - 12:57:38 CDT
