Re: How to display output screen by screen in SQLPLUS on windows

I thought you could do it by typing "set pause on" at the sql prompt before running your query. But on 9.0.1, this crashes SQL*Plus, so I can't confirm it.

You could also do something like:

sql> spool c:\temp\myfile.txt

run your query

select...

sql> spool off

This will send the output of your query to c:\temp\myfile.txt You can then review the output in an editor.

"YJ2002" <yanjunxu_at_umich.edu> wrote in message news:vIiR9.635$8N2.17030_at_news.itd.umich.edu...
> Hi, Dear All,
>
> This may be simple. But I'm a beginner of Oracle. Some SQL query outputs
 are
> very long. I don't know how to pause after each screenful of information.
> Could anybody help me with this? Thanks a lot.
>
> Sincerely,
> Yanjun
>
>
Received on Fri Jan 03 2003 - 19:36:08 CET