Re: Select First 500 Rows of a Table

melliott42_at_yahoo.com (Michael) 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

set pause on
set pagesize 500

Depending on what exactly you are trying to do.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20040818/news_1c18scibrief.html