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 -> FETCH a Specific Amount of Rows from Query

FETCH a Specific Amount of Rows from Query

From: gilgantic <gilgantic_at_yahoo.com>
Date: 22 Apr 2003 09:42:08 -0700
Message-ID: <d6052717.0304220842.f348aac@posting.google.com> 





Hi,



I know in DB2 you can use the FETCH keyword to get a specific amount of rows
from a query. Example, SELECT * FROM A FETCH FIRST 10 ROWS ONLY, will return
on the first 10 rows of a result set. How is this done in Oracle 8i., or is
it even possible? The FETCH keyword is used differently in Oracle 8i as I
understand it.



Thanks!


Gil
Received on Tue Apr 22 2003 - 11:42:08 CDT












Original text of this message













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