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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possible to send output of sqlplus console to a file?

Re: Is it possible to send output of sqlplus console to a file?

From: Michael L. Hostbaek <carlos_at_pez.dk>
Date: 30 Apr 2003 13:20:47 GMT
Message-ID: <slrnbavjdf.toi.carlos@freebsdcluster.dk>


Peter tried to tell us something, and all I got was:
> Is it possible to send output of sqlplus console to a file, for Oracle
> 8 and 9?

Yes. Like this:
SQL> spool test.out
SQL> desc dual

 Name                            Null?    Type
 ------------------------------- -------- ----
 DUMMY                                    VARCHAR2(1)

SQL> spool off

-- 
Regards,
Michael L. Hostbaek
-= So long, and thanks for all the fish.. =-
Received on Wed Apr 30 2003 - 08:20:47 CDT

Original text of this message

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