Re: Remove blanks from SQLPlus spoot output

From: ddf <oratune_at_msn.com>
Date: Fri, 22 May 2009 13:58:08 -0700 (PDT)
Message-ID: <40bad3a9-853d-48ad-bbb7-3403e82239af_at_m17g2000vbi.googlegroups.com>



On May 22, 3:44 pm, ddf <orat..._at_msn.com> wrote:
> On May 22, 3:06 pm, nickli2..._at_gmail.com wrote:
>
> > Hi,
>
> >     Is there a  set or format command in SQLPlus that will remove
> > leading whitespaces from fields? Essentially I want to output comma-
> > delimited files with no spaces before or after columns.
> > I know I could probably concatenate the fields using "|" or use
> > UTL_FILE package and PL/SQL. This is however undesirable as there are
> > large number of columns and a lot of ad-hoc queries need to be run.
>
> >     Thanks in advance.
>
> >     Nick
>
> No.  You'll need to use ||','|| between column names to generate the
> output you want.
>
> David Fitzjarrell

Why re-invent the wheel when Tom Kyte has a procedure/function/script to do this same thing?

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:95212348059

David Fitzjarrell Received on Fri May 22 2009 - 15:58:08 CDT

Original text of this message