| sql plus question [message #200835] |
Wed, 01 November 2006 09:29  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
