Re: SELECT

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: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
>>
>>
>

-----= 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 - 11:41:47 CDT