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

On May 22, 3:06*pm, nickli2... (AT) gmail (DOT) com wrote:
No. You'll need to use ||','|| between column names to generate the
output you want.


David Fitzjarrell

On May 22, 3:44*pm, ddf <orat... (AT) msn (DOT) com> wrote:
Why re-invent the wheel when Tom Kyte has a procedure/function/script
to do this same thing?

http://asktom.oracle.com/pls/asktom/...ID:95212348059


David Fitzjarrell