Spooling to a file without select stmt [message #18901] |
Wed, 20 February 2002 12:58 |
Susan
Messages: 102 Registered: October 2001
|
Senior Member |
|
|
I want to spool results of a sqlplus query to a file. I want to keep my headings, I have pagesize set to 9999 so that I won't get blank rows in between data and have feedback turned off to eliminate the record totals. I want the output to look like a pretty report. :-) I can't get rid of the formatting commands (column,ttitle,etc.) and select command in the text file. It is making me nuts! I've tried set termout off and set echo off and can't see any change in the results. Any ideas??
|
|
|
|
|