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>
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