Home » SQL & PL/SQL » Client Tools » How can we remove the substitution from SPOOL (Oracle 9i)
How can we remove the substitution from SPOOL [message #391024] Tue, 10 March 2009 13:02 Go to next message
ravashingravi
Messages: 7
Registered: March 2008
Location: India
Junior Member
Hi

I am trying to spool the output of a query in file. In the query i am using a variable.
While spooling the substitution lines are also spooled

****************************************************************
credits which are not covered in GL_DATA.
****************************************************************

old 9: WHERE t.trans_date = '&ACT_DATE'
new 9: WHERE t.trans_date = '05-MAR-2009'

TRANS_ID CREDIT_AMT GL_AMT
--------- ---------- ------
135415001 95.00 52.10

Is there anyway to supress this while spooling.
Re: How can we remove the substitution from SPOOL [message #391026 is a reply to message #391024] Tue, 10 March 2009 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set verify off

Regards
Michel
Re: How can we remove the substitution from SPOOL [message #391028 is a reply to message #391026] Tue, 10 March 2009 13:08 Go to previous messageGo to next message
ravashingravi
Messages: 7
Registered: March 2008
Location: India
Junior Member
I have these in the beginnig already.

set pages 1000
set lines 200
set line 100
set verify off
SET SERVEROUTPUT ON;
Re: How can we remove the substitution from SPOOL [message #391029 is a reply to message #391024] Tue, 10 March 2009 13:10 Go to previous message
ravashingravi
Messages: 7
Registered: March 2008
Location: India
Junior Member
Thanks its done... Razz
Previous Topic: Getting Errror in run to SQL* loader in TOAD
Next Topic: ora12154 - error
Goto Forum:
  


Current Time: Sun Dec 11 03:58:02 CST 2016

Total time taken to generate the page: 0.09288 seconds