Re: How to redirect output to a file

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 24 Jun 2004 14:36:20 GMT
Message-ID: <EFBCc.10208$HS3.7157@edtnps84>

Andy wrote:

> I am using sqlplus console and would like to direct the output to a
> file. How can I achieve this? Thanks

There are several wonderful documents that answer this question:

SQL*Plus Getting Started for Windows
SQL*Plus Quick Reference  
SQL*Plus User's Guide and Reference

available free of charge at http://docs.oracle.com

Your relevant search word is 'SPOOL'. Note that the next common querstion is related to formatting the output and then wrapping long text. Check out COLUMN. (Beyond those hints ... a recent Dilbert cartoon around consulting fees comes to mind. <g>)

/Hans Received on Thu Jun 24 2004 - 09:36:20 CDT