Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Save Query Output to a File?
Spool file.txt
run your query
spool off
In article <3534965B.7041_at_med.pitt.edu>,
Joe Condle <condle_at_med.pitt.edu> writes:
> How can you save a SQL query to a file? I am running Oracle 8
> on a Sun Solaris machine. All I want to do as save the ouput of
> the select statement to a text file instead of having it scroll off
> the screen. I have searched through all the documentation.
>
> Thanks in Advance
>
> Joe Condle
> Sys Engr.
> Medical ARchival Sys. Inc.
> University of Pittsburgh Medical Center
> condle_at_med.pitt.edu
Received on Thu Apr 16 1998 - 19:05:24 CDT
![]() |
![]() |