Remove blanks from SQLPlus spoot output
Date: Fri, 22 May 2009 13:06:31 -0700 (PDT)
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