Remove blanks from SQLPlus spoot output

From: <>
Date: Fri, 22 May 2009 13:06:31 -0700 (PDT)
Message-ID: <>


    Is there a set or format command in SQLPlus that will remove leading whitespaces from fields? Essentially I want to output commadelimited  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 Received on Fri May 22 2009 - 15:06:31 CDT

Original text of this message