Re: Setting number of row returned
From: Michel Dion <mdion_at_mlink.net>
Date: Fri, 5 Jun 1998 09:43:16 -0400
Message-ID: <6l8se4$juu$1_at_neon.Mlink.NET>
Date: Fri, 5 Jun 1998 09:43:16 -0400
Message-ID: <6l8se4$juu$1_at_neon.Mlink.NET>
Add this to your select statement:
Where Rownum = nn
Michel Dion
CPA
Andy Hering wrote in message <35774EE1.46089882_at_ibm.net>...
>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
>
>
Received on Fri Jun 05 1998 - 15:43:16 CEST