Re: select rows 770000 until 770005 in a large table Correction to my previous reply

OK so my math skills are a little weak...

< 780000 - < 750000 returns all between 750000 and 779999 ; in the question posted however, I should have said

Select * from table_name where rownum < 770005 minus
select * from table_name where rownum < 769999 This should return rows 770000 to 770005 ( assuming no inserts between the 2 select statements)

Sorry...
( rest of comments still apply)  

johng_at_mm.com (TurkBear) wrote:

>
>Tho it might not give you the information you want, you can try this:
>
>Select * from table_name where rownum < 780000
>minus
>select * from table_name where rownum < 750000
>
>This should return rows 750000 to 799999 ( assuming no inserts between the 2
>select statements)
>
>
>Not very efficient and may take a long time, but it should do it...
>
>hth,
>
>Roland Schmidt <schmidtr_at_hager.de> wrote:
>
>>
>>
>>Andy Hardy schrieb:
>>
>>> In article <3897FE06.543EFCE1_at_hager.de>, Roland Schmidt
>>> <schmidtr_at_hager.de> writes
>>> >In Oracle 8.0.5 I need to select some rows from a large table starting
>>> >with the 770000th row in this table without knowing the key.
>>>
>>> If you don't have a key why do you want the 770000th row?
>>>
>>> In an RDBMS the concept of the 770000th row does not really mean
>>> anything, what are you trying to achieve?
>>>
>>> Andy
>>> --
>>> Andy Hardy. PGP key available on request
>>> ===============================================================
>>
>>I want to get the key.
>>The reason is a problem during a Software upgrade (SAP).
>>In our test system everything works well and in our production system the
>>upgrade stopped with an error due to create the primary index after
>>inserting 770005 rows.
>>Now I try to find out why it works in one system and not in the other. I
>>may help to get the key of row 770006, you know ?
>>
>>Roland
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
>------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Feb 02 2000 - 19:13:39 CET