Home » SQL & PL/SQL » SQL & PL/SQL » sql plus question
sql plus question [message #200835] Wed, 01 November 2006 09:29 Go to next message
charles.gardner
Messages: 2
Registered: November 2006
Junior Member

By setting echo off I can get rid of the sql showing up in the file, except where variable subsitution occurs then it seems to always print the following as an example...

old 31: where to_date( ('20' || substr(cust_cpst,2,6)), 'yyyyddd') between sysdate - &tooOld and sysdate - &oldStores or
new 31: where to_date( ('20' || substr(cust_cpst,2,6)), 'yyyyddd') between sysdate - 180 and sysdate - 2 or
old 32: to_date( ('20' || substr(mach5_cpst,2,6)), 'yyyyddd') between sysdate - &tooOld and sysdate - &oldStores
new 32: to_date( ('20' || substr(mach5_cpst,2,6)), 'yyyyddd') between sysdate - 180 and sysdate - 2

How can I get rid of that in the spool file. I have set everything I can think of to off and still cant get rid of it.
Re: sql plus question [message #200836 is a reply to message #200835] Wed, 01 November 2006 09:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
SET VERIFY OFF
Re: sql plus question [message #200837 is a reply to message #200835] Wed, 01 November 2006 09:44 Go to previous messageGo to next message
Mike Bentley
Messages: 8
Registered: September 2006
Junior Member
Have you tried SET VERIFY OFF?

Mke
Re: sql plus question [message #200838 is a reply to message #200835] Wed, 01 November 2006 09:45 Go to previous message
charles.gardner
Messages: 2
Registered: November 2006
Junior Member
Thanks ....Didnt see that one...

Charles
Previous Topic: unable to update table
Next Topic: DB report in Browser
Goto Forum:
  


Current Time: Sun Dec 04 20:41:16 CST 2016

Total time taken to generate the page: 0.06879 seconds