Re: Setting number of row returned
Date: Fri, 05 Jun 1998 06:38:48 GMT
Message-ID: <6l83po$qio$1_at_nnrp1.dejanews.com>
There is a standard field ROWNUM, which like ROWID is available.
To limit the response, try
select bunches
from sometable
where thereis=qualifiers
and rownum < 100;
This would limit the return to 100 rows.
Be aware, however,that the rownum is assigned before any sorts(such as in an 'order by').
In article <35774EE1.46089882_at_ibm.net>,
foco018_at_ibm.net wrote:
>
> Hi,
>
> I'm looking for a way to set the number of row returned in a query
> using SQL*PLUS. I know Sybase uses ROWCOUNT to do this, but is there a
> similar feature in Oracle. I haven't found anything in the
> documentation available to me.
>
> Thanks!
> Andy
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 05 1998 - 08:38:48 CEST