Re: View result one screen at a time

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Wed, 14 Apr 1999 11:45:45 +0530
Message-ID: <37143290.D361107E@india.hp.com>

you can just say set pause on
ansd requery the table

regards
vittal

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 Wed Apr 14 1999 - 01:15:45 CDT