Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Select First 500 Rows of a Table

Select First 500 Rows of a Table

From: Michael <melliott42_at_yahoo.com>
Date: 17 Aug 2004 14:04:40 -0700
Message-ID: <91721cf.0408171304.50618189@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
Received on Tue Aug 17 2004 - 16:04:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US