Re: Setting number of row returned

Andy,

Use rownum, ie "select x from foo where rownum < 5"

--
Tom Mettling
WT Chen & Company, Inc.
mettling_at_volpe.dot.gov


Andy Hering 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