Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> View result one screen at a time

View result one screen at a time

From: <yong321_at_yahoo.com>
Date: Wed, 14 Apr 1999 04:10:39 GMT
Message-ID: <7f14fq$b79$1@nnrp1.dejanews.com>


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:10:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US