SET TERMOUT OFF does NOT seem to work
504552Feb 6 2007 — edited Feb 6 2007Hello, I have the following script that I am executing and it is returning over 30,000 rows. I am trying to supress terminal output but it does not seem to work. Any suggestions? I am running Oracle 9.2.0.7.0 64 bit on SUN Solaris 5.9.
The following SQL is in a file called SlowQuery.sql:
SET TIMING ON TERMOUT OFF
SPOOL SlowQuery.log
select
o.selling_outlet_id,
o.order_id,
o.order_date,
f.fulfill_outlet_id,
o.order_type,
o.event_timestamp,
f.shipping_amount,
f.tax_amount,
f.total_price
from
orders o,
order_fulfillment f
where
o.order_id = f.order_id
and o.transition_seq = f.transition_seq
and o.order_date between TO_DATE('2007-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and TO_DATE('2007-01-31 23:59:59','YYYY-MM
-DD HH24:MI:SS')
and o.order_id like '03%'
and o.transition_seq = 0
order by
o.selling_outlet_id,
o.order_id;
SPOOL OFF