Home » SQL & PL/SQL » SQL & PL/SQL » Spooling to a file without select stmt
Spooling to a file without select stmt [message #18901] Wed, 20 February 2002 12:58 Go to next message
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??
Re: Spooling to a file without select stmt [message #18902 is a reply to message #18901] Wed, 20 February 2002 13:01 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Set pagesize 0; to turn page breaks off completely.
set echo off; to suppress your commands
set verify off; to suppress variable substitution form being displayed
Re: Spooling to a file without select stmt [message #18925 is a reply to message #18901] Thu, 21 February 2002 06:08 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
place spool command just before sql statement (means after formating statements)
Previous Topic: how to get list of all child tables for a particular parent table
Next Topic: Difference Between OERR-1422 and OERR-2112
Goto Forum:
  


Current Time: Fri Sep 17 02:46:23 CDT 2021