| suppress parameters in spool file [message #288811] |
Tue, 18 December 2007 15:10  |
ottsompol
Messages: 9
Registered: December 2007
|
Junior Member |
|
|
Hi thank you for helping.
I have a sql script with user input dates (begin-end). The data is spooled to a file but at the top of the spool file, it has the paramters. I just want the results. I've already tried set echo off, running as a script @myfile.sql. Please help. It is due soon. Thanks again
|
|
|
|
|
|
| Re: suppress parameters in spool file [message #288821 is a reply to message #288817] |
Tue, 18 December 2007 16:19  |
ottsompol
Messages: 9
Registered: December 2007
|
Junior Member |
|
|
result
old 13: ,TO_CHAR(TO_DATE('&startdate','DD-MON-YYYY'),'MMDDYYYY')
new 13: ,TO_CHAR(TO_DATE('01-nov-2007','DD-MON-YYYY'),'MMDDYYYY')
old 14: ,TO_CHAR(TO_DATE('&enddate','DD-MON-YYYY'),'MMDDYYYY')
new 14: ,TO_CHAR(TO_DATE('01-dec-2007','DD-MON-YYYY'),'MMDDYYYY')
old 28: AND (ob.BOOKING_BEGIN_DATE BETWEEN '&startdate' AND '&enddate')
new 28: AND (ob.BOOKING_BEGIN_DATE BETWEEN '01-nov-2007' AND '01-dec-2007')
111111111TPV317FALLEN JASEY JAKE
222222222TPV317ALMAGUER RAYMOND MOLL
333333333TPV317LANI XASEM
desire result:
111111111TPV317FALLEN JASEY JAKE
222222222TPV317ALMAGUER RAYMOND MOLL
333333333TPV317LANI XASEM
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
