Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SET TERMOUT OFF does NOT seem to work

504552Feb 6 2007 — edited Feb 6 2007
Hello, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2007
Added on Feb 6 2007
10 comments
1,919 views