Re: Remove blanks from SQLPlus spoot output

From: ddf <>
Date: Fri, 22 May 2009 13:44:12 -0700 (PDT)
Message-ID: <>

On May 22, 3:06 pm, 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

Original text of this message