Re: formatting output with SQL*Plus

"Thomas Kellerer" <NNGNVRDSJEBN_at_spammotel.com> wrote in message news:31oqp1F3d2fp2U1_at_individual.net...
> What I'm basically doing is:
>

<snip>
> spool output.txt
>
> SELECT column1,column2, column3
> FROM my_table;
>
> spool off
>
> Is there any way to remove the trailing spaces in the column values?

cheap and ugly select trim(column1),trim(column2) ....

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com