OraFAQ Forum: SQL & PL/SQL » Spooling to a file without select stmt

Home » SQL & PL/SQL » SQL & PL/SQL » Spooling to a file without select stmt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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??

Report message to a moderator

Re: Spooling to a file without select stmt [message #18902 is a reply to message #18901]

Wed, 20 February 2002 13:01

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

Report message to a moderator

Re: Spooling to a file without select stmt [message #18925 is a reply to message #18901]

Thu, 21 February 2002 06:08

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

place spool command just before sql statement (means after formating statements)

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:01:14 CDT 2024