OraFAQ Forum: Client Tools » How can we remove the substitution from SPOOL

Home » Other » Client Tools » How can we remove the substitution from SPOOL (Oracle 9i)

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

How can we remove the substitution from SPOOL [message #391024]

Tue, 10 March 2009 13:02

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.

Report message to a moderator