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 -> Re: Data scrolling of the screen?

Re: Data scrolling of the screen?

From: Greg Kainz <gregkainz_at_attbi.com>
Date: Tue, 11 Dec 2001 03:45:09 GMT
Message-ID: <9jfR7.31184$ER5.333180@rwcrnsc52>


set pagesize nnn;
-- where nnn is number of lines to display set pause on;

--
select lotsarows from my_table;
--note; another ENTER required, as the page pauses before showing the first
row
row 1
row 2
...
row (pagesize)...

"ROBERT WEST" <rob-west_at_worldnet.att.net> wrote in message
news:_8eR7.290592$W8.9772508_at_bgtnsc04-news.ops.worldnet.att.net...

> When I perform a SELECT statement and the data scrolls off the screen, how
> do I pause the screen by screen to view the data? For example: In DOS
dir
> /p
>
> Thank you,
> Rob-west @worldnet.att.net
>
>
>
Received on Mon Dec 10 2001 - 21:45:09 CST

Original text of this message

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