Home » Other » Training & Certification » suppress parameters in spool file
suppress parameters in spool file [message #288811] Tue, 18 December 2007 15:10 Go to next message
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 #288817 is a reply to message #288811] Tue, 18 December 2007 15:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you have and what you want. It is not clear from what you said.

Regards
Michel
Re: suppress parameters in spool file [message #288821 is a reply to message #288817] Tue, 18 December 2007 16:19 Go to previous messageGo to next message
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
Re: suppress parameters in spool file [message #288823 is a reply to message #288821] Tue, 18 December 2007 17:25 Go to previous message
ottsompol
Messages: 9
Registered: December 2007
Junior Member
I solved my own problem. set verify off

thanks for your email Michael Razz
Previous Topic: Oracle Configurator
Next Topic: Does oracle certification expires?
Goto Forum:
  


Current Time: Thu Dec 08 10:33:44 CST 2016

Total time taken to generate the page: 0.10487 seconds