Re: Setting number of row returned

From: <mpir_at_compuserve.com>
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

Original text of this message