Xref: alice comp.databases.oracle.tools:39425 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!dispose.news.demon.net!demon!news.demon.co.uk!demon!ahardy.demon.co.uk!aph From: Andy Hardy Newsgroups: comp.databases.oracle.tools Subject: Re: select rows 770000 until 770005 in a large table Date: Wed, 2 Feb 2000 12:22:23 +0000 Organization: England Message-ID: References: <3897FE06.543EFCE1@hager.de> X-Trace: news.demon.co.uk 949497290 nnrp-06:21851 NO-IDENT ahardy.demon.co.uk:158.152.45.183 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 X-Newsreader: Turnpike (32) Version 4.01 Lines: 14 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 ===============================================================