Remove blanks from SQLPlus spoot output

    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