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

From: YJ2002 <yanjunxu_at_umich.edu>
Date: Fri, 3 Jan 2003 14:24:09 -0500
Message-ID: <urlR9.643$8N2.16877_at_news.itd.umich.edu>


Thanks a lot for your help. I really appreciate it.

Yanjun

"Darren" <darren.cuthere_at_mallette.cut_cut_cut.com> wrote in message news:sKkR9.141376$E_.54790_at_news02.bloor.is.net.cable.rogers.com...
> 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 - 20:24:09 CET

Original text of this message