Before executing any command spool it. For Example: sqlplus "/ as sysdba" spool output.log Select tname from tab where tname; spool off exit No check the output.log file
Thanks and Regards, Altaf Shaikh (OracleAppsDBA) --- On Wed, 5/20/09, ashok abraham <[email protected]> wrote: From: ashok abraham <[email protected]> Subject: [LinuxVadaPav] How to redirect oracle sql query output to a text file To: [email protected], [email protected] Date: Wednesday, May 20, 2009, 6:05 PM Dear all How to redirect oracle sql query output to a text file instead to console Regards ashok Explore and discover exciting holidays and getaways with Yahoo! India Travel http://in.travel. yahoo.com/ [Non-text portions of this message have been removed]
