Xref: alice comp.databases.oracle.tools:39454 From: johng@mm.com (TurkBear) Newsgroups: comp.databases.oracle.tools Subject: Re: select rows 770000 until 770005 in a large table Correction to my previous reply Date: Wed, 02 Feb 2000 18:13:39 GMT Reply-To: See Message body for real address Message-ID: <389b728a.163891894@204.181.81.99> References: <3897FE06.543EFCE1@hager.de> <3898324C.55BC7565@hager.de> <38996dee.162711977@204.181.81.99> X-Newsreader: Forte Agent 1.5/32.451 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: 2 Feb 2000 12:07:12 -0600, 156.98.4.11 Lines: 75 X-Authenticated-User: turkbear X-Report: Report abuse to abuse@newsfeeds.com X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body X-Abuse-Info2: ALL Spam complaints are acted upon within 24 hours! Organization: Newsfeeds.com http://www.newsfeeds.com 60,000+ UNCENSORED Newsgroups. Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.icl.net!skynet.be!feed2.newsfeeds.com!newsfeeds.com!goliath.newsfeeds.com!newsfeeds.com!156.98.4.11 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@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 wrote: > >> >> >>Andy Hardy schrieb: >> >>> In article <3897FE06.543EFCE1@hager.de>, Roland Schmidt >>> 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 ==-----