Home » SQL & PL/SQL » SQL & PL/SQL » spool query
spool query [message #357600] Thu, 06 November 2008 00:31 Go to next message
diamond
Messages: 26
Registered: July 2008
Junior Member
Hi
is there any way that my spool file should not display the sql query??
It should only have the answer of the query.

Please reply soon Smile

thanks in advance
Re: spool query [message #357601 is a reply to message #357600] Thu, 06 November 2008 00:35 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Try SET ECHO

Smile
Rajuvan.
Re: spool query [message #357604 is a reply to message #357601] Thu, 06 November 2008 00:46 Go to previous messageGo to next message
diamond
Messages: 26
Registered: July 2008
Junior Member
it helped..

thanks
Re: spool query [message #357608 is a reply to message #357601] Thu, 06 November 2008 00:51 Go to previous messageGo to next message
diamond
Messages: 26
Registered: July 2008
Junior Member
also..
1 more thing i wanted to ask u..

is it possible to eliminate the

_ _ _ _ _ _ _ _ _ _ (the string of underscores) which comes under the result od sql..

ex :

VERSION ID
------------------------------ ----------
COMMENTS
--------------------------------------------------------------------------------
HOST NAME DATABASE
---------------------------------------------------------------- ---------


is actually causing my output to look ugly
Re: spool query [message #357626 is a reply to message #357608] Thu, 06 November 2008 01:26 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*PlusŪ User's Guide and Reference
Chapter 12 SQL*Plus Command Reference
Section SET System Variable Summary

Regards
Michel

[Updated on: Thu, 06 November 2008 01:26]

Report message to a moderator

Previous Topic: Tables used in stored procedure
Next Topic: send email to multiple reciepient using utl_smtp
Goto Forum:
  


Current Time: Thu Dec 08 03:52:05 CST 2016

Total time taken to generate the page: 0.11075 seconds