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

Home -> Community -> Usenet -> c.d.o.tools -> Restrict number of rows returned?

Restrict number of rows returned?

From: tore <TBostrup_at_teamia.com>
Date: Fri, 29 Dec 2000 10:13:56 -0500
Message-ID: <cR136.8$E%1.209@client> 






Is there a way in Oracle (8.0.5) to restrict the number of rows returned
from a query (using SQL Worksheet or SQL*Plus)?



(Something similar to either SELECT TOP n * or SET ROWCOUNT n in SQL
Server).



The restriction must be carried out on the server side since I am testing
some queries that return large result sets over a slow communications linkto
review the results of a "batch" application.




Thanks,


Tore.
Received on Fri Dec 29 2000 - 09:13:56 CST












Original text of this message













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