Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Save Query Output to a File?

Re: Save Query Output to a File?

From: tree <root_at_best.psi.net>
Date: 17 Apr 1998 00:05:24 GMT
Message-ID: <6h66c4$gl5$1@usenet1.interramp.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US