Re: sqlplus question

Hi Johan,

You need to use the following:

SET PAU[SE] {OFF|ON|text}

Allows you to control scrolling of your terminal when running reports. ON causes SQL*Plus to pause at the beginning of each page of report output. You must press [Return] after each pause. The text you enter specifies the text to be displayed each time SQL*Plus pauses. If you enter multiple words, you must enclose text in single quotes.
You can embed terminal-dependent escape sequences in the PAUSE command. These sequences allow you to create inverse video messages or other effects on terminals that support such characteristics.

You can toggle the 'more' behavior after you set the pause text with SET PAUSE ON or SET PAUSE OFF.

Mike Rose

mmrose_at_home.com

Johan den Boer <jj.den.boer_at_hccnet.nl> wrote in message news: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 ?
Received on Thu May 06 1999 - 15:48:20 CDT