Re: View result one screen at a time

Try this:
SET PAGESIZE 24
SET PAUSE "M o r e . . ."
SET PAUSE ON This should let you view 24 lines at a time with a bottom of the screen prompt like
M o r e . . .

HTH yong321_at_yahoo.com wrote:

> In SQL*Plus, is it possible to view a SELECT result one screen at a time like
> you do it at the command line with "| more"? The closest I can think of is say
> "where rownum<20" and then say rownum between 20 and 30, etc. But is there a
> way to press one key to view the next "batch" of lines? Thanks.
>
> Yong
> Email:ynog321_at_yahooc.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 13 1999 - 23:30:28 CDT