Re: Avoiding spooling to empty files
From: ddf <oratune_at_msn.com>
Date: Sat, 31 Jan 2009 08:03:47 -0800 (PST)
Message-ID: <34ca62a7-5059-4e1f-8ae8-4398220b2e20_at_k1g2000prb.googlegroups.com>
On Jan 30, 6:27 pm, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> Thanks Joel,
>
> Actually it is very usefull.
>
> I'll try to implement it.
>
> The only inconvinient is that i'm migrating a lot of scripts that
> worked fine (generated zero-lenght files when no data found).
>
> So i'll still need the trick for Oracle.
>
> Thanks.
Date: Sat, 31 Jan 2009 08:03:47 -0800 (PST)
Message-ID: <34ca62a7-5059-4e1f-8ae8-4398220b2e20_at_k1g2000prb.googlegroups.com>
On Jan 30, 6:27 pm, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> Thanks Joel,
>
> Actually it is very usefull.
>
> I'll try to implement it.
>
> The only inconvinient is that i'm migrating a lot of scripts that
> worked fine (generated zero-lenght files when no data found).
>
> So i'll still need the trick for Oracle.
>
> Thanks.
set trimspool on
That causes SQL*Plus to 'trim' the trailing spaces, and it may just fix your 'problem'.
David Fitzjarrell Received on Sat Jan 31 2009 - 10:03:47 CST