Re: Export to a ascii, tab delimited file

Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
>
>>set trimspool on
>
>Just for completeness (and please correct me if I'm wrong): this will
>not affect the output of normal SQL queries, which might be captured
>from SQL*Plus using redirection.
>
> sqlplus scott/tiger _at_my_script > my_spool.txt
>
>will still have the trailing blanks.

That is correct. In this case you can trim blanks from the standard output with:

set trimout on

It is a nice option to have in one's login.sql

-- 
   _at_..@    Marti Rijken <mrijken_at_prv.gelderland.nl>
  (`--')   private mail: mrijken_at_natrix.demon.nl
 ( >__< )  URL:  http://www.natrix.demon.nl/