Re: How can I limit the NUMBER of rows returned?
From: Craig Kasold <cdg_at_ix.netcom.com>
Date: 2 Feb 1995 13:15:06 GMT
Message-ID: <3gqlsq$kfk_at_ixnews1.ix.netcom.com>
Date: 2 Feb 1995 13:15:06 GMT
Message-ID: <3gqlsq$kfk_at_ixnews1.ix.netcom.com>
In <3ghgbr$g3l_at_news-s01.ca.us.ibm.net> ebsmith_at_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 Received on Thu Feb 02 1995 - 14:15:06 CET