From: cdg@ix.netcom.com (Craig Kasold)
Newsgroups: comp.databases.oracle
Subject: Re: How can I limit the NUMBER of rows returned?
Date: 2 Feb 1995 13:15:06 GMT
Organization: Netcom
Lines: 18
Distribution: world
Message-ID: <3gqlsq$kfk@ixnews1.ix.netcom.com>
References: <3ghgbr$g3l@news-s01.ca.us.ibm.net>
NNTP-Posting-Host: ix-dc5-18.ix.netcom.com


In <3ghgbr$g3l@news-s01.ca.us.ibm.net> ebsmith@ibm.net writes: 

>
>Doing selects from Solaris middleware with ProC to an Oracle7 server.  
>Returned tables are normally small & quick, but occasionally we get a 
 query
>which returns way too many rows so that even the first fetch is greatly 
 delayed.
>I'd be happy to take the first 100 rows quickly, and ignore the rest.
>Any suggestions?  
>                                                                   
 --Baird Smith
>

Baird,
   add a where clause ---> where rownum < 100;
   you could also increase the array parameter.
Craig