Re: Remove blanks from SQLPlus spoot output

From: ddf <oratune_at_msn.com>
Date: Fri, 22 May 2009 13:44:12 -0700 (PDT)
Message-ID: <515a7a2f-4b34-49b6-b6f6-ea4e48037051_at_e24g2000vbe.googlegroups.com>

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 Received on Fri May 22 2009 - 15:44:12 CDT