Re: SQLPlus - How to spool without query string?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Sep 2005 16:36:59 -0700
Message-ID: <1127518556.793788_at_yasure>


Isa wrote:
> Hi:
> you can put at the beginning of the select:
> set termout off
> set arraysize 5
> set echo off
> set verify off
> set heading off
>
> This removes all the text from the query result. Only remains the
> values of the select
> I hope it's usefull to you.
> Regards,
> Isa

Why arraysize 5? That should do nothing but slow down the query by quite a bit. I'd suggest you try with an arraysize of 100-200 as a general rule.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Sep 24 2005 - 01:36:59 CEST

Original text of this message