Re: sqlplus question

From: hdt <etullis_at_mindspring.com>
Date: Thu, 6 May 1999 23:35:07 -0400
Message-ID: <7gtno6$kig$1@nntp9.atl.mindspring.net>

Johan,

Before you start the query, do this...

set pause on

Then it will stop at every pagesize. You can also do something like set pause on "Hit return..."
and it will prompt you. Don't know if I got the syntax correct.

One gotcha, it will pause before scrolling the first set, so if you believe your query is taking too
long, hit return!

Good luck!

Johan den Boer wrote in message <3731DD56.AB1D9FFA_at_hccnet.nl>...
>Hello,
>
>We have a table of say a 300 rows. If I do a select * from my_table all
>the
>answers are scrolling of my screen. How can I tell sqlplus to stop after
>
>20 rows and continue if you press a key. Do you have something like
>'more' command in sqlplus ?
>
>Johan den Boer
>
>jj.den.boer_at_hccnet.nl
>
Received on Thu May 06 1999 - 22:35:07 CDT