Re: SQLPlus, How do you limit number of rows?

In article <3A54C66C.FFEEA858_at_seas.upenn.edu>,   Sharon Diskin <diskins_at_seas.upenn.edu> wrote:
> Hello,
>
> Could someone tell me how to limit the number of rows
 returned/displayed
> from a select statement in SQLPlus? I thought this could be
> accomplished using ROWNUM, but, this does not appear to be possible.
>
> Thanks,
> Sharon
>
>

There are a set of parameters that can be set to determine how SQLPlus returns information.

PAGES or PAGESIZE determine the number of rows displayed before a new page is generated. 0 is for no page breaks.

HEADING : displays the column names at the start of each page.

Check in the SQLPlus manuals / documentation CD.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/