Re: SQL*Plus:how to redirect result to a file?

Steve <sfang88_at_yahoo.com> schrieb in im Newsbeitrag: 3A1D96CF.85D4A8FE_at_yahoo.com...
> Hi everyone! Can anyone tell me how to redirect a query result to a file
> so that I can browse it later on? Another question: how to let the query
> result show up page by page instead of scrolling down to the bottom?
> Sometimes the query result is really long. Thanks!

Hi Steve,

to first:

spool c:\tmp\spoolfile
select ..... from .. where ...;
spool off

to second:

set pause on

(Assuming you talk about SQL*Plus...)

regards

--
Holger Kreft
====================
Verlion GmbH, Essen
EMail: Holger.Kreft_at_Sutter.de