Re: Select First 500 Rows of a Table

From: Bob Jones <email_at_me.not>
Date: Tue, 17 Aug 2004 22:51:03 GMT
Message-ID: <rZvUc.1757$zw3.934@newssvr24.news.prodigy.com>

"Michael" <melliott42_at_yahoo.com> wrote in message news:91721cf.0408171304.50618189_at_posting.google.com...
> Hello,
>
> In Oracle 8.17 from SQLPLus how can I SELECT the first 500 rows of a
> table? I am versed in creating (filtering out) data using a WHERE
> clause - this is different than that.
>
> I ideally would like to SELECT the first 500 records of a table then
> the NEXT 500 and so forth.
>
> Thanks for your advice,
>
> Michael

First 500 rows by what? Received on Tue Aug 17 2004 - 17:51:03 CDT